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.
excel-formula
32,031
questions
2
votes
4
answers
65
views
Using Excel O365, How to use unique on two columns, sort, and copy over related data?
I have a 4 column, dynamic row array with names, process, order #, and dates. The array is dynamic and being collected using FILTER() function and grabbing the 4 columns I want from a table on a ...
-1
votes
0
answers
28
views
Convert value in excel to SHA256 and upload in digital ad platforms
I am not sure how if this can be achieved by excel or not.
However, sharing my concern below.
I have my customer data in a .csv file which contains email id and phone number.
My end objective is to ...
2
votes
1
answer
51
views
Algorithm for adjusting formula excel from original cell to destination cell
I am trying to parse formula in excel with 3 params: Formula, original cell address, destination cell address.
Example, with some rules:
Formula
Original Address
Destination Address
Result ...
2
votes
2
answers
60
views
excel - how to pick the whole row using randbetween
I'm trying to pick a random row from my dataset shown below.
I'm wanting to pick out 2 rows from the list at random, with column C being the column that is randomized and column D to match with the ...
0
votes
1
answer
26
views
Error when using hashtag in Data Validation in Excel
I am using Macbook Sonoma and am struggling to use # in the Worksheet. I have a dynamic column in a separate sheet called Lists that will have new values, so I am using the below formula to make sure ...
0
votes
4
answers
95
views
Calculating expected count based on hierarchy structure
I am working on a hierarchy excel sheet and I need some help. In the columns A-F is depicted an organization hierarchy. I need a function that provides values for column 'Expected count'.
Here I have ...
0
votes
1
answer
34
views
EXCEL: formula to extract data from a table [duplicate]
EXCEL:
I have a table in the cell range A2 to G4.
I want to find a value that can be in any cell in the range A2 to F4 and display the corresponding value in column G.
I've tried creating forums with ...
0
votes
3
answers
57
views
IF AND and conditional formatting question
I am trying to find the right formula for the below situation. Not sure if conditional formatting is the answer or a formula or a combination. I have reviewed guidance for how to use IF and IFS as ...
0
votes
3
answers
54
views
Excel: sort an array by an ordered list, without custom list
I have a table of post codes, with the amount of shipments being sent to each postcode.
I want to sort this array by post code in a specific order, which I have in a second list.
I do not wish to sort ...
1
vote
1
answer
47
views
Excel returns #VALUE! error when I use INDIRECT
I'm new to Excel and I'm writing an Excel formula that counts the employees state across the entire year( for example: how many times he had a vacation donated as letter V)
and I managed to write this ...
0
votes
6
answers
81
views
Multiple Conditions in Excel considering the table2
I have a data set contains city names.
Table1:
Table2:
I want to apply the Table2 condition .
Exclude USA means "<>USA"
I can do it without considering the Table2 by taking the ...
-5
votes
0
answers
56
views
Transpose tab-delimited dataframe [closed]
I have a tab-delimited .txt file containing:
1 Julia aa bb
8 William dd ee ff gg
which I want to reform this as below:
1 Julia aa
1 Julia bb
8 William dd
8 William ee
8 ...
0
votes
1
answer
42
views
Returning a value from column of the last row of entry sheet, if a value is less than another value in
Below I am summarizing a step by step process on what I am looking to do:
This screenshot shows where I am entering the data (the sheet is called Entry_Sheet, in this problem, I am focusing on the &...
-3
votes
2
answers
68
views
Turn table into a list
I have this table of what people are missing on each month, and what are they missing(maked as missing) or they have(marked with an "X") or if the guy wasn't working at that time, it says ...
0
votes
0
answers
26
views
Set an excel cell/range formula which contains quotation mark error. (0x800A03EC))
I use interop.excel library.
I want to set this string to the formula of some excel range: =HA(VAGY(C2="83V";C2="8U";C2="9V");"nem";"igen")
English: =...