Questions tagged [worksheet-function]
Questions about using in-cell functions/formulas in spreadsheet software.
2,596
questions with no upvoted or accepted answers
-2
votes
1
answer
156
views
How do I create a range from a cell value?
For example:
A B
7926 3 FROM =COUNTIF(AQ$7926:AQ7970,"=0")
7926 3 FROM =COUNTIF(AQ$7926:AQ7971,"=0")
7926 3 FROM =COUNTIF(AQ$7926:AQ7972,"=0")
7926 3 ...
-2
votes
2
answers
12k
views
Conditional Formatting with greater than & less than parameters based on date in cell
Trying to conditionally format a cell based on the date in the cell. My ultimate goal is to try and track warranty expiration dates on some of the product we maintain. Within 30 days of expiration ...
-2
votes
1
answer
76
views
How do I show the formula behind a cell with real values rather than cell reference?
Say cell A1 is 10, cell A2 is 20, cell A3 is A1+A2, which is 30. In A4, I want to show the text "10+20". Excel functions like FORMULATEXT can only print out A1+A2. FYI, I don't like using ...
-2
votes
2
answers
125
views
Using INDEX/MATCH to return a value from a set of tables
I'm having a hard time writing an INDEX/MATCH formula. I need the formula to look through multiple rows to find the one that matches my lookup value. I have multiple headers for different months.
The ...
-2
votes
1
answer
168
views
How to compare number with number in other column and get corresponding value
If suppose I have data like
column1 column2
504231 504109
504109 504201
504201
504299
then I used the following formula =IF(ISNA(VLOOKUP($A2,$B$2:$B$5,1,0)),"",VLOOKUP($A2,$B$2:$B$5,1,0)...
-3
votes
1
answer
546
views
Excel: How to have a cell change color when it has the same value as another cell?
I have used conditional formatting to change a row's color for specific values of another cell before but now I want it to change color when the value of a cell is equal to the one next which all have ...
-3
votes
1
answer
67
views
Finding the year in another table in Excel when the value isn't the same
I have two tables. I would like to get the data from Blue to the Orange table with following steps:
The first column of Orange table has both positive and negative values as percentage, and I need to ...
-3
votes
1
answer
976
views
Using VLOOKUP with Conditional Formatting
I am attempting to utilize conditional formatting to handle a lot of the legwork on a project I'm working on, which relates to the ordering of skills for a roleplaying game. Unfortunately, after ...
-3
votes
1
answer
66
views
Excel: Count if values match
I basically have two predetermined worksheets with data in a format I can't modify the way it populates.
On one sheet "SSP" I want to check row I against row E on a different sheet "YMS" to check for ...
-3
votes
1
answer
151
views
Excel - IF formula for multiple cells
I have 5 cells with either 1, 0 and -1 values.
I want to build a formula that allows me to have, for example, a 0 or a -1 if any of those 5 cells are a 0 or a -1.
Can you please help? Thanks.
-3
votes
1
answer
302
views
Lookup that Use a cell that contains range as lookup value and lookup vector
Sorry, I can't post image here because of restriction. But, I can't find another way to explain my problem.
I have a sheet like that. And then, I need cell B5 to return a value based on data from ...
-3
votes
2
answers
170
views
AVERAGE function not working
I Have two columns containing dates.
I used this formula to find how many days there were in between the dates:
=DATEDIF(J7,K7,"md") &""
This produces the number of days without putting the ...
-4
votes
2
answers
89
views
amount calculation in excel
I have a payment amount of 2628.46. This payment should be used to pay off, in turn, three components listed in columns BZ, CA and CB. So, first I subtract the April Principal from the May payment. If ...
-4
votes
1
answer
84
views
How to sum in Excel with month logic?
Mentione in the picture, I have 2 Excel sheets, Sheet 1 with ID Q1 and Z1, and NAME in column and month in rows. And in Sheet 2, I have ID Q1 and Z1 with the amount in month column.
My requirement ...
-4
votes
1
answer
167
views
Based on input value, place an associated object in another cell
I have a collection of predefined input codes. When an input code is entered in an input cell, I want to automatically post an associated object in an output cell. For example, using the code table ...