All Questions
35
questions
0
votes
1
answer
7k
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 ...
- 5
1
vote
2
answers
2k
views
How to insert a line break in a concatenated cell in Excel 2003
In Microsoft Excel 2003, I use the following formula [in cell A2 in a sheet named (Allocation)] to refer to several cells from a sheet named (02Mis)
='02Mis'!$A$4&"/"&'02Mis'!$A$11&"/"&...
- 249
1
vote
1
answer
669
views
How do I add 1 month to a specific date once that date has passed?
I have an excel sheet that lists our current due date. The due dates are the same day of each month (9/2, 10/2, etc) and I want the due date to update once the old date passes so I don't have to do ...
- 23
0
votes
3
answers
124
views
Joining 3 Excel IF Statements
I'm trying to join the following 3 IF statements in Excel but every time i try i get an argument error or else it reverts back to displaying "True" or "False" instead of "Miss Window", "Hit", "Not ...
- 55
0
votes
1
answer
38
views
In this data set, I want to get the most recent or three most recent numbers for a particular day. How can I get this?
This is the data set I have :
Date Day Number
8/29/2016 Mon 63
8/30/2016 Tue 58
8/31/2016 Wed 66
9/1/2016 Thu 61
9/2/2016 Fri 61
9/3/2016 Sat 67
9/4/2016 Sun 70
9/5/2016 ...
0
votes
2
answers
1k
views
How to put comma into digits like eastern (especially Indian) style by using a formula in M S Excel?
Friends I want to put comma automatically into the digits like this-
10,00,000
Or
1,00,000
For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,...
- 181
0
votes
1
answer
717
views
How to fill up gaps in excel
My data in excel has for example the following data in columns A and B:
A B
1 4
2 6
5 88
9 67
12 45
and so on.
I would like to transform it as following:
A B
1 4
2 6
3 0
4 ...
- 103
1
vote
1
answer
616
views
Checking column for value. If true, check same row in another column and count if not blank
I have a spreadsheet of employees. Column A is a list of Dept types (sales, HR, payroll, etc). Column B is the date their appraisal is completed, or blank if incomplete.
I would like a function that ...
- 11
2
votes
2
answers
212
views
How to extract remainder of a match of 5 digits in 9
I am trying to extract the "remainder" (the non-matching portion) of a search using Excel 2003. I tried using various combinations of functions but it seems that there's no specific function that can ...
5
votes
3
answers
38k
views
How to find the last value in a column in excel?
I am tracking rooms booked in a hotel on a daily basis in Excel. Every day I input the number of rooms booked in a column to show a trend of pick up over a period. I'd like to return the value of ...
- 51
0
votes
1
answer
624
views
Search from bottom with multiple criteria
I am trying to search a data table in excel and find the bottom most row that meets a specific criteria. I thought I could use this LOOKUP trick but it only returns a #DIV/0 error. This is what I ...
- 269
1
vote
1
answer
4k
views
Microsoft Excel lookup match without sorting data
Have a value list and need to insert points by looking up the data table. Data table has value for points in 1000 increments. Actual value that I lookup will not be rounded to 1000 so I tried using ...
- 326
0
votes
3
answers
235
views
Excel Using Reference for Worksheet names [duplicate]
I've looked around to try and resolve this, however I am unfamiliar with the coding.
Here's my line of code,
='[WorkBook]BOM'!G6
What I want to do is make the Workbook call to a cell so I can mass ...
- 1
2
votes
1
answer
544
views
how to determine which values in a given set of cells will add up to a numerical range
In other words, I'm looking for a sum range that consists of combinations of cells from an array. Given a set of numbers:
1 720 56 17 59 120 153 203 39 1 690 583 582 561 256 310 232 95 108 16
26 ...
- 21
1
vote
1
answer
930
views
How do I create a list of phone numbers for people whose reference numbers appear in two columns?
I have two sets of data in columns A & B and also in columns C & D. Some of the content in column C & D does not appear in columns A & B:
A = reference numbers
00001, 00002, 00003, ...
- 13