Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

0
votes
0answers
3 views

Reorder spreadsheet based on values in two columns

I have an Excel 2010 spreadsheet with lots of product data across many columns and 20,000 rows. Two of the columns are for parent and child categories. A product with different sizes or colours will ...
0
votes
0answers
18 views

Macros Created in Excel 2016 Not Working in Excel 2010

I create a file with the same macro in Excel 2016 to send out to people in my company. Users on Excel 2010 were able to use the macro last month, but when I sent them a file with the same macro today, ...
0
votes
1answer
27 views

Excel bar chart widths displaying incorrectly

Using the following data to create a bar chart displays incorrect bar widths. Yes No a 7 0 b 7 0 c 6 1 Shows As you can see, the widths for c are incorrect. The 'No' column is ...
1
vote
1answer
19 views

How to automatically delete blank row/cells when export to other worksheet?

I have a few raw data files which some row/cell does not have data. How do I automatically delete those empty row/cells when I move/export the data to other work sheet. what formula should I use to do ...
1
vote
2answers
31 views

Any keyboard shortcut to navigate to the most recent worksheet in Microsoft Excel 2010

I'm working with a workbook which has got 11 worksheets. I have frequently switch between worksheets. Mostly I work between different pairs of worksheets. If I use the mouse, sometimes I have to ...
0
votes
0answers
25 views

Microsoft Excel: Insane slow with thousands of xls-Comments

I'm generating xlsm/xlsx files with Python and writing thousands of xls-Comments to the file and I'm wondering why it's slowing Excel so much down. There's no problem if I output an Excel-file with ...
0
votes
1answer
37 views

Multiple columns into one column without blanks

I'm using Microsoft Excel 2010. I have multiple columns with data in them, and some blank cells too. I'm using this formula: =INDEX($A$101:$F$200;MOD(ROW()-ROW($A$201)-1;ROWS($A$101:$F$200))+1;INT((...
0
votes
1answer
33 views

How to copy color of the conditional formatting cell to another excel file

On one sheet I have a data which has conditional formatting color. I want to copy and paste that into another file, I was able to paste value, column width etc. but I couldn't paste the color from ...
0
votes
1answer
32 views

Excel - Bar chart - years in y-axis and variables in x-axis

I'm trying to chart the following: I want a bar showing the total fruit I want the fruit in the Y-axis The years in the X-axis - so you can visually see the impact per year of each category. ...
-2
votes
1answer
31 views

Excel - Show if a cell (in the same column) has a value below it, not a blank

I need some help please, I'm trying to save time as I'm working with 100k+ rows. I'm trying to find a way of finding out when there is information on 2 consecutive cells, one below the other. I've ...
0
votes
1answer
43 views

Excel pivot values column to Text

I have data in Excel pivot and my text data in value column shows number instead of Text . Any one can help me please. In below image of pivot value field red circled:
-2
votes
1answer
50 views

HOW TO SEPARATELY VISIBLE A ROW CONTENT BASED ON VALUE-without VB

I have some data from 2A to 9D. I want a separate box and need to show all details of particular row based on the age I wish. In the example I want to filter all data of a customer with age 15.(I ...
0
votes
2answers
53 views

How to sum numbers in parenthesis within a cell until a certain condition is met?

Here's the problem, I got a cell, say, WH,QC-NDE(0.75),CHL150-1(5.05),HMCT12P1(1),B-S(0.2),QC-NDE(0.5),TIGPEC05(17.25),SR,CHL150-1(23),HMCT12P1(42),B-S(1.5),QC,QC-H(0.35),QC-NDE(0.75),INSP_FIN(1) ...
1
vote
3answers
107 views

How can I count how much wood a woodchuck chucks using Microsoft Excel?

TL;DR Is there anything like grep in Excel that can help me count whole-word-only instances (e.g. "wood" but not "woodchuck") (and maybe their variations)? So there's this poem, by mother goose: ...
18
votes
2answers
2k views

Excel week number inconsistent results

I am using a spreadsheet that includes the week number for a particular date. After some research, I found a function ISOWEEKNUM() that I could apply to a column of dates and this appeared to work ...

15 30 50 per page