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

**2**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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

**1**answer

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 ...