Stack Exchange Network

Stack Exchange network consists of 174 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 about using in-cell functions/formulas in spreadsheet software.

2
votes
2answers
46 views

Excel Formula to Adjust Remaining Budget Evenly for Each Remaining Days

Need your help for the formula that can adjust remaining amount evenly. I need to use a formula that will adjust remaining amount of budget plan based on remaining days. From this case, Since the ...
3
votes
1answer
35 views

Do Excel UDFs update when you apply sort

As the question suggests, I'm seeing side effects (slowness) of the UDFs I've created when I apply a sort to my spreadsheet. I've created some UDFs in .NET and have deployed for testing. The function, ...
3
votes
1answer
37 views

TEXTJOIN() on an array incorrectly returns a blank

TL;DR: TEXTJOIN() on an array returns a blank - can't use VBA to solve the issue in an alternative way. I've created several sheets with heavy dependence on Array functions due to limitations ...
0
votes
1answer
41 views

Excel organization

I have made a sample version of what I would like. This form is ever repeating and the amounts values in the middle rows vary at all times. I would like to know if you know of a way to make the far ...
0
votes
1answer
44 views

Find conditional frequency of unique text entries in Excel?

So I've had a look around the Internet and I'm running into a brick wall with everything I've tried. I have an Excel worksheet with two columns of data; 'Country' and 'Shape'; below is a small sub-...
2
votes
1answer
36 views

Calculating the average (“hitrate”) of football results

I want to find the average (or the "hit rate") of World Cup football results. I have calculated 2 points for correct 1X2, and 3 points for correct 1X2 + correct score. So the hit rate should be "yes" ...
2
votes
2answers
28 views

Count each time the same value appears for a person, resetting when a new value is displayed

I have an Excel spreadsheet with two columns: Col 1 = Department, Col 2 = Employee Name I would like to count each time the same department appears for the employee and reset the count when a new ...
3
votes
2answers
72 views

How to calculate the average of the 2 previous rows when a zero is found in excel

I have thousand of rows in excel and I need to average the 2 preceding rows every time a zero is found. For example Column1 23 12 0 32 10 0 I need the average of 23 and 12 to replace the zero found ...
2
votes
1answer
16 views

Lookup value in a row based on keyword

I'm trying to lookup a value in a row based on a keyword and return the value. Example: Column 1 Column 2 Column 3 Result http://1stexample.com http://...
1
vote
3answers
71 views

Cross compare data between 2 workbooks

I'm trying to cross compare 2 data in 2 different workbook. Then, I need to find the missing data between the 2 and make a separate new, updated list. However, I only need to update the data if there'...
1
vote
1answer
36 views

References in color-scale conditional formatting formulae for ranges

I'm using Libreoffice Calc (v6.1b). Suppose I have numeric data in sheet column, A and I'm applying conditional formatting to sheet column B. I want each cell of B to have a color on a scale ...
0
votes
2answers
33 views

Search cell contents in an entire workbook and return a specific cell from that sheet

I'm trying to create a formula to get a string of text specified in A3 (text is T1234-1234) and to search this string in another workbook on a specified line, but on all sheets until a match is found ...
1
vote
2answers
38 views

Excel: show list of values based on query in range

I have a table like this: a | tomato b | pear c | tomato d | pear I would like to create a formula that lets me select which rows contain tomato and which ones contain pear. ...
0
votes
1answer
21 views

trying to compare dates using If function

Using the IF function I am trying to return a value if two months match i.e. basically =IF(A2=$B$1,A4,""). Cell A2 has the date typed in, B1 is =TODAY(), both are formatted to show the month which ...
2
votes
1answer
17 views

Extract last row cell reference using excel formula

How to return the cell reference of the last row of data present in a column? I want to pass it as input to index match. I tried using the combination of Address and counta. It returns a string and I ...

15 30 50 per page