Stack Exchange Network

Stack Exchange network consists of 175 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 [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

0
votes
2answers
19 views

Excel - Any smart way to take the first line in each cell and move it to the last line?

I have a few sheets that I need to move the first line of each cell to the last line. For example this is one cell: Chris / Mike / Ralph Henry / Steve Mark / Bob Would become Henry / Steve Mark / ...
0
votes
0answers
19 views

How to highlight a ColumnName in Excel

I have multiple column names and I want to highlight only those column names in which there are multiple rows containing 'False' as value. So that I can easily find out which columns have 'False' ...
0
votes
0answers
14 views

Defining a whole column as a range in COUNTIFS function

I was wondering if someone could help me with a formula. I have a spreadsheet with two worksheets, the first being called "Datasheet". In the second worksheet, I want to be able to select all of ...
1
vote
3answers
55 views

Using TODAY in Excel to calculate the next instance of a date within a certain number of months?

Edit to clarify: the date returned MUST be less than 24 months from the current date because this is an expiration date, and the items must expire at the correct time unless renewed. Another way of ...
0
votes
1answer
25 views

Even more variables in once cell on excel

Someone very kindly answered this question for me the other week but now I need to make it even more specific: How can I have a cell display a one of 3 different predetermined figures based on the ...
1
vote
0answers
12 views

Excel formula to find date in given range (entire column)

I was actually trying to write a formula to match and find a date in the entire column. So say suppose I have something like this in sheet1: A | B -------------------- ID | Date1 ---...
0
votes
0answers
23 views

How do I do VLOOKUP or INDEX/MATCH for more than one range?

I have been trying to figure out a way to fill up the ratings column (image below) without getting into lengthy formula. I have tried VLOOKUP and 'INDEX/MATCH` but have gotten to a dead end. In a ...
0
votes
0answers
16 views

calculate networkdays between two dates but exclude holiday (however depend on value)

i need excel formula to calculate networkdays that exclude weekend and holiday. however the holiday depends on the destination set of data start date = column a end date = column b destination = ...
0
votes
1answer
33 views

Google Spreadsheet Formula for Weekend Dates

In Google Sheets, what formula can I use to create a list of weekend dates where each row shows the next upcoming Sat/Sun as follows: 05/18/2019 - 05/19/2019 05/25/2019 - 05/26/2019 06/01/2019 - 06/...
1
vote
1answer
40 views

How do i make a conditional formula that will take into account summing and zeroing out within the same row?

I need to write a formula that will continue to sum up deficits and gains across a row in a running total when the total remains a negative number (not out of the deficit) but then gives a running ...
0
votes
0answers
15 views

In Excel, how do I change the target range for a Pricetable being queried by an INDEX/MATCH array formula?

So in the image you see two price tables, in fact there will be many more than this. On another sheet there are cells marked "width" and "drop" and when values are entered in these fields, a 3rd field ...
0
votes
2answers
18 views

Return Date Once Value Falls Below Criteria in Excel

I haven't been able to find a solution to my current problem so hopefully my request will help others here as well. I have data arranged as follows(pls see screenshot attached, I am not yet able to ...
-1
votes
0answers
11 views

How to MATCH or VLOOKUP all values in a column to match another

I have a dataset of 6500+ values that I need to match with another sheet within spreadsheet. External Value Column 'F' in Sheet A has values that I need to verify if the same value (long ID number) ...
1
vote
0answers
11 views

Excel - Reference Value where multiple conditions are met

I am finding it extremely difficult to translate a simple SQL Style Lookup into excel. I have data spread about multiple excel sheets which I am trying to combine into one sheet/table automatically. ...
0
votes
0answers
15 views

Group by , sort and difference

Please help me derive formula to calculate the difference in Excel after group by and sort by, In the above excel want to group the columns values "Process Unit,Process Name" and sort by "Time", and ...

15 30 50 per page