Questions tagged [microsoft-excel-2010]

The 2010 version of Microsoft's spreadsheet application.

Filter by
Sorted by
Tagged with
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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
-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. ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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(...
user avatar
  • 101
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, ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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-...
user avatar
  • 213
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 ...
user avatar
  • 111
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 ...
user avatar
  • 103
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-...
user avatar
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 (...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 3
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 , ...
user avatar
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 ...
user avatar
  • 1
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!
user avatar
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 ...
user avatar
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 ...
user avatar
  • 3
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 ...
user avatar
  • 5
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&...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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 = ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 1
-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....
user avatar
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 ...
user avatar
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. ...
user avatar
  • 1
-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, ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 &...
user avatar
  • 101
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 ...
user avatar
  • 1
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 ...
user avatar
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 '...
user avatar
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 ...
user avatar

1
2 3 4 5
92