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,030
questions
2
votes
1
answer
26
views
Algorithm for parse 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 Expected
...
- 72
2
votes
2
answers
48
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 ...
- 31
0
votes
1
answer
22
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 ...
- 9
0
votes
2
answers
58
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 ...
- 1
0
votes
1
answer
32
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 ...
- 31
0
votes
3
answers
46
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 ...
- 1
0
votes
1
answer
43
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 ...
- 97
1
vote
1
answer
45
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 ...
- 13
0
votes
5
answers
67
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 ...
- 23
-5
votes
0
answers
52
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 &...
- 87
-3
votes
1
answer
56
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 ...
- 1
0
votes
0
answers
25
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: =...
- 21
-2
votes
2
answers
57
views
How to display value retrieved from column CMDB [duplicate]
How to display value retrieved from column CMDB
I want the column business service on the left to return the value based on the CMDB table
How can I achieve to do that?
IP address
business service
...
- 31
0
votes
0
answers
35
views
Need Vlookup and Indirect Formula
I've never used the Indirect formula so looking for some help.
I want to reference the Offer # on the 'Summary' tab to look up the Total Qty Ordered value on the tab titled #1.
So, for Offer #1 (cell ...
- 1