# Questions tagged [excel-formula]

This tag is for Microsoft Excel questions where the question or answers are specifically about the structure, syntax, or output of an Excel formula.

25,306
questions

**0**

votes

**1**answer

33 views

### How to get the next matching item in row Excel

I have a table with data and I'm struggling with getting the next match data in the row.
I've tried many options with no success and every time I'm getting the same solution.
can someone help/guide me ...

**-2**

votes

**0**answers

30 views

### Select a column in excel and has the R[-13]C[-2] stuff from macro recording in it

This is my code, but it doesn't work.
Range("F17").Formula = "=IF(COUNT(R[-13]C[-2]:R[-10]C[-2])=0,10^99,COUNT(" & Range(Range("D4"), Range("D4").End(...

**-2**

votes

**1**answer

24 views

### Excel - Searching and extracting a specific text into new cell [closed]

I Have a long string/text in excel, I want to extract a specific text into new cell as shown in picture below

**0**

votes

**3**answers

32 views

### How To List All Dates Between Two Dates In Excel?

I have tried the formula to generate dates between start date and end date and it is not working properly.. I would need help here
Image from excel
formula = =IF($D$5+ROW(D5)>=$D$6-1,"",...

**0**

votes

**2**answers

35 views

### Excel: To create a Boolean Counter function that refreshes itself like the Rand() function

I lack the knowledge of VBA so need help to create a function counter that works as follows:
int ctr = 1;
ctr = ctr + (-1)^ctr;
print ctr;
Here I want this function [written in C++ style above] to ...

**0**

votes

**3**answers

31 views

### filter out duplicate records with 0 instance

I have the below data set in excel which I am trying to filter out based on the value in next column.
What I am trying to do here is if there is any 0 values present in SH-001, the whole record set ...

**-3**

votes

**1**answer

35 views

### is there an excel formula to find the last occurrence of distinct values for all dates? [closed]

enter image description here
i am looking to assign a value in c column 1 if it is the last occurrence of each distinct task of each date. Only through formula. Only where there is a duplicate. Rest ...

**0**

votes

**1**answer

28 views

### Need help from expert>< Any way can help to auto allocate data into cells based on certain criteria[refer to hyperlink for photo explaination]

i'm trying to allocate those supply into my demand. The supply will be allocate by FIFO according to the ready date. Is there any formula or script can help to perform those auto allocation instead of ...

**2**

votes

**2**answers

56 views

### Convert Horizontal Table Info in Vertical Table With Formulas

I have multiple rows of data for different users. Some users have multiple entries and some will only have one. All this info is stored in a '1 row per user' format. My goal is to show all this info ...

**-1**

votes

**2**answers

35 views

### How to find the lowest and highest date based on certain value in another column?

I have an excel table like this which contains Name and Date as shown below. I want to find out the lowest and highest date based on Name on right side.The right table already contains the Name. I ...

**0**

votes

**0**answers

29 views

### Why am I receiving #VALUE! error using BASE64SHA1?

I am trying to create a hash of a string using the UDF BASE64SHA1.
Public Function BASE64SHA1(ByVal sTextToHash As String)
Dim asc As Object
Dim enc As Object
Dim TextToHash() As Byte
...

**0**

votes

**1**answer

18 views

### How to see if multiple columns match different conditions and return text

I'd like to return a "u" if the cell to the left is in column I on my other tab AND if the cell underneath is in column F on the other tab. How would I go about this please?
So far I have in ...

**0**

votes

**1**answer

27 views

### Formula to display certain string value based on the contents of cells of other sheets

I have a Master sheet that contains formulas that is based on the combination of the cells in other sheets in an excel file. The Master sheet displays a string value (Available/Not Available/Blank(...

**0**

votes

**1**answer

32 views

### Excel: Dependant Data Validation Listing values from table with criteria without Macro

I would like to create a data validation field that draws values from a table, but only those values where a corresponding value matches a cell reference: the Month
Ideally this should be done ...

**1**

vote

**1**answer

45 views

### In excel, can you create a named range from multiple values (linestring) within a single cell?

I was wondering if I can make a named range from a linestring in a single cell, like "1,2,3,6,7" or "1-3, 6-7", instead of having to type each value in its own cell.
In column C of ...