# Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

4,589
questions

0
votes

0
answers

47
views

### How to split text from one cell into multiple cells

Hope somebody can make this task a bit easier for me.
Basically, i'm transferring notes from and Excel spreadsheet into our CMS platform. My main problem is the Excel entries are all on a single line, ...

0
votes

1
answer

26
views

### Merging two lists in Excel

The Situation:
I have two teams both on separate sheets of an excel document writing out the info of people they talk to each day (Name, customer number, Date etc).
The third team want a sheet with ...

0
votes

0
answers

18
views

### Why am I getting a blank cell with Calibri font and bold designation? [closed]

I can see my cell content in the address bar, but if bold is on the cell appears blank. If I press bold and the italics key then the cell content is visible. Very strange occurrences and only ...

-1
votes

0
answers

32
views

### String value of date not converting and returning error

The dates in column B are in string type, I have:
Used Delimeters.
Formatting Cells to date form
Tried using the =DATEVALUE() and =VALUE() to extract the number value yet its gives the #value! error.
...

0
votes

1
answer

19
views

### SUM function returning 0 value

DATA SET PREVIEW
I Used the sum function to calculate the time, as the trip duration is in seconds i used =SUM(cell/60) and then convert them to HH:MM:SS, but some of the cells are returning 00:00:00
...

0
votes

0
answers

19
views

### Auto adjust cell values if one cell values changed

how to adjust values automatically if cell values A1 has changed means then the changed values has to adjusted with B2 values and the final cumulative values remains unchanged.
Suppose i have list of ...

0
votes

1
answer

15
views

### I have a worksheet with multiple tab and i want to separate each tab that contains same text into a separate sheet

I have a worksheet with multiple tabs, can i get a VBA code that will separate each tab into multiple files
I want to make A1 and A1 SCREEN as one file, then B1 and B1 SCREEN be on another file and ...

0
votes

0
answers

30
views

### How to keep track of review dates in Excel 2010

I am trying to help my sister with Excel, but her work has 2010 and everything I suggest to her is returning #VALUE. I am currently on Excel 365 and everything I suggest to her is working for me and ...

1
vote

1
answer

39
views

### Excel Formula to display date when cells are filled in

I have a table and I need a excel formula that says the following:
If Cells C1, E1 and F1 are filled out, than today's date will appear. However if Cells C1, E1 and F1 are not filled out, than the ...

0
votes

3
answers

56
views

### Calculate average in excel excluding cell contains date or zero or text

In B6 I want to calculate average for range c6:h6 skipping cells which has date, zero or non text values.
Result should be - 400
I tried using averageif with filter ex: =AVERAGE(FILTER(C6:H6,ISNUMBER(...

1
vote

1
answer

25
views

### Is it possible to link an entry in a filtered sheet to the master sheet, matched on a key variable? (Excel)

I am trying to link a column in a filtered sheet to another column in the master sheet using a key category (i.e., id). Below is the illustrated dataset:
[]
As shown above, I have the master sheet, ...

0
votes

4
answers

52
views

### How do I get VLOOKUP to return all results not just one (using formula not auto-filter)

I have a table full of several orders and the dates. On another page i want to be able to type in a date and for all orders to show from that date, like a VLOOKUP. But, a VLOOKUP would only display ...

0
votes

1
answer

38
views

### Excel Pivot display multiple columns

I had a Salary data month wise now i want to calculate the difference between last 2 months salary field wise
below is the sample data
Required Sample output of single employee.
I have tried using ...

0
votes

1
answer

24
views

### Convert from table to matrix format with Excel 2010

I would like to convert this data from table to matrix format where the names in the dest column become columns and the number values corresponds to the total but the origin column stands still
origin ...

0
votes

1
answer

21
views

### Transferring Excel2010 .xlsb files to new PC using Office365

Are there likely to be significant problems transferring large Excel2010 .xlsb files (~10MB) from a WIN7 PC running Office2010 to a new WIN11 machine running Office365 Personal? There are no user-...

1
vote

0
answers

15
views

### Win10 - Excel 2010 - Need macro to place hyphens between each letter of a single Hebrew word in a cell

The goal is to separate each Hebrew letter of each word of the Tanach/Old Testament into separate cells. If I manually place hyphens between each letter in a word, then Text to Columns will place each ...

0
votes

1
answer

43
views

### Find Closest Match (Conditional Lookup)

I am trying to do conditional lookup in Excel (MacOS). Let's say I have the table shown below, and I want to search for (type=alpha, length=165). In the table, there isn't an exact match so I'm trying ...

0
votes

2
answers

35
views

### Index Function with error "You've entered too many arguments for this function"

=index(_70Rain,1+int((row(b4)-1/columns(_70Rain)),mod(row(b4)-1+columns(_70Rain),columns(_70Rain))+1)
I just followed the code given in https://www.extendoffice.com/documents/excel/1172-excel-...

0
votes

0
answers

29
views

### Excel formula add on needed for vlookup

So I have a simple vlookup formula to tell me if an item number is billable or not. However, when the value isn’t give(T or F) I do not get an output. However I want to use the invoice number (...

0
votes

0
answers

18
views

### Excel previously changed text to dates. How do I get it back to what I originally typed?

I have a large Excel (xlsx) spreadsheet full of various types of data. I had initially downloaded this data from Google Sheets. At some point (I'm not sure when), one of my columns of data that had ...

1
vote

2
answers

56
views

### Converting positive number values to boolean TRUE in excel

I'm trying to sum up all the entries based on several specific conditions.
The goal is to count all entries that have a 'yes' ticked in them in cells J or K or L or M and have '1st' in H
This is the ...

0
votes

0
answers

24
views

### Prioritizing work based on 2 expiration dates in a2 and b2

here is what I have so far,
=if(A2="","",LOOKUP(A2-TODAY(),{-120,5,10,15,120},{"Critical","Critical","High","Medium","Low"}))
But ...

0
votes

1
answer

36
views

### Microsoft Excel- prioritizing based on two date columns

I have two due dates I have to look out for at work, and I want to have a priority column that assigns a critical, critical,high, medium, low , low priority if either of those dates are within -120 , ...

0
votes

1
answer

59
views

### Subtract all numbers in a range from the largest number and sum the differences - SOLVED

I’m trying to sum the differences between the largest value in a range and all the other values in the range. Then take the second largest value in the range and sum the differences between that value ...

0
votes

2
answers

40
views

### Excel Custom Ribbon Separators

I was looking for a way to insert vertical separators into a custom ribbon in Excel 2010, which seems to be problematic for everyone. I've searched the planet and been told it can't be done!

0
votes

1
answer

22
views

### Highlight entire rows based on cell values

I want to highlight entire cell values when the row values changes.
For example, row contains
A
A
B
B
B
C
D
E
E
Final result : i want to highlight above the row by means of A has to in one color and B ...

0
votes

1
answer

30
views

### How to perform same operation on non concurrent excel cells

I am trying to perform the same operation on excel on a range of non-concurrent cells.
Let's say I have range C:C, within this range I need to perform this operation IF(ISNUMBER(C2),(C2*A2),(0)). How ...

0
votes

1
answer

41
views

### How to conditionally format if not on list?

Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells).
For example, a list of ...

0
votes

2
answers

62
views

### Excel VBA - Dynamic Array not Working

I am trying to make an array that stores all of the values in Column A from "Workbook B" so I can then reference and see if a cell's value is in that array in Column A from "Workbook A&...

0
votes

0
answers

12
views

### Excel VBA - Check if Cell Value is in a Different Workbook

I am trying to write some code that checks in a cell's value in Column A is in a different workbook in Column A.
I need the code to loop through every cell in "Workbook A" and check if it's ...

0
votes

1
answer

70
views

### formula to autofill with condition and skip blank cells

I have the master sheet and data sheet (more than 1 but same format)
This is the example of the data from the sheet
Project (Column C)
Details (Column E)
Project A
Laptop
Printer
Camera
blank
...

0
votes

1
answer

29
views

### Is there a way to count how many cell with a certain value are above a certain cell in excel?

So I have a list here of whatever that are ranked 1-40th. Only those that were top30th in the previous ranking will have a letter designation. jan-20 column shows the previous top30th having the ...

1
vote

1
answer

59
views

### How to setup an offset function so it will take values from table horizontally and will go 2 rows down every 6 cells

I'm trying to automate prices on my parents online shop and I've got pretty messy data to work with. I converted csv file with prices from site to xlsx and pasted there tables from the database.
I've ...

0
votes

2
answers

292
views

### Excel VBA - If Statement Checking If Value is in Array

I have a lot of variables I have stored in an array. I am trying to use an If Then statement to see if the value of a specific cell is in that array. Here is my code:
Dim Vars1 As Variant
Vars1 = ...

0
votes

0
answers

33
views

### Excel VBA - InStr in a Variable Range

I am trying to use a for loop to loop through the cells in a column and pick out parts with a specific description. To do this, I am using InStr, which I am unfamiliar with.
Here is the code I have ...

0
votes

0
answers

22
views

### How to keep referenced data and non-referenced data interlocked?

I am pulling information over from sheet 1 to sheet 2. Sheet 2 is basically a workflow for a different department. It is using core information from sheet 1.
The issue I am running into is when a row ...

0
votes

0
answers

34
views

### Attempt using ISBLANK formula not working with conditional formatting

I am attempting to use the ISBLANK formula for conditional formatting. What I am wanting to do is if the C column cell is blank then the called out rows in that cell have no formatting. Like this:
If ...

0
votes

1
answer

18
views

### Excel VBA - Selecting Row in For Loop

I have a for loop that goes through Column I and looks for when the value exceeds a certain point. It then inserts a row.
I need to edit this row. I need to merge a portion of it and insert text and ...

0
votes

0
answers

29
views

### Reference a list in word VBA

I have a large mail merge document where I'm trying to find and replace certain text variables with the mail merge fields.
I have the code below, but am wanting to reference a list of objects to fill ...

-1
votes

1
answer

35
views

### Live Time in Excel

I am looking to get the Live time in Excel.. All I want is E.g. If(Now()="08:00","Yes","No")
For this I would need the live time as I see Now is constant and not changing....

0
votes

1
answer

37
views

### Tried multiple IFS formula. None is working

So I have a column which has country names plus a few blanks.
So I want the formula to go by this :
IF the country name is "India" put it as India and if the country name is anything else ...

0
votes

0
answers

28
views

### Cell input utilizes formula to show new value

I'm looking to have a cell that changes after I input my value. What's going on is that I have data that I get from an outside reference, in one form (millimeters of mercury) that I enter into a cell. ...

-1
votes

1
answer

50
views

### Restarting excel serial number

I wants to add a auto serial number into my excel sheet which should restart from 1 automatically as soon as the text in the next column changed. For example I have column of subjects i.e English, ...

0
votes

0
answers

38
views

### Combine then count combination of text in cells in a table

I have an attendance table that I need to verify every day. Every day different employees are billed on different projects, locations, and hours. Each has individual columns while the employees have ...

0
votes

0
answers

20
views

### Excel VBA: how to apply 2 color gradiants to the same cell based on cell values?

I'm trying to apply 2 different color gradients to the same cell. The gradients are based on other cell values.
When using conditional formatting, only one is applied.
If using VBA this code would ...

0
votes

2
answers

47
views

### Calculate the sum of individual categories in microsoft excel

I am trying to work on a Accounting finance sheet for budgeting. I am stuck here. I want to calculate the sum of individual categories in "Actual Expenses" column. For example - The sum of &...

0
votes

0
answers

28
views

### Specific users cannot open Excel 2010 on Windows server 2010

I have a Windows Server 2012 installation with multiple users. They are mostly identical and serve the same purpose - and are therefore members of the same groups (administrators included).
Whenever ...

0
votes

2
answers

37
views

### Multiple if functions that won't generate a too many argument error

The following formula worked until I added the last IF statement. I understand at the core what this errror means due to researching it. However, I cannot figure out what I need to do to keep the ...

0
votes

0
answers

28
views

### How to get referenced data from another sheet to update

I am referencing several cells from one sheet to another. In an attempt to compile specific data. What is occurring is that when the data from the 'CL Upcoming' sheet is modified, the data on the '...

0
votes

1
answer

58
views

### Conditional Formatting not updating when referencing new data from another sheet

I have a sheet called 'Email' in which I reference cells from the sheet 'CL Upcoming'. What I am finding is that when I add new rows to the 'CL Upcoming' sheet that the new rows in the 'Email' sheet ...