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.

0
votes
1answer
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
0answers
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
1answer
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
3answers
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
2answers
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
3answers
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
1answer
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
1answer
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
2answers
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
2answers
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
0answers
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
1answer
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
1answer
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
1answer
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
1answer
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 ...

15 30 50 per page
1
2 3 4 5
1688