All Questions
Tagged with worksheet-function spreadsheet
223
questions
1
vote
2
answers
1k
views
Excel: Using nested IF statements containing wildcard characters
I'm currently working on a project where I have a list of patient visits to a clinic. Each patient is assigned a Primary Care Provider, but that's not always the Rendering Provider at a given visit. ...
1
vote
1
answer
213
views
Excel formula for comparing columns where text IS LIKE
I work as a data analyst in a clinic and we're currently working on determining how many patients saw their assigned provider at their last visit. I typically run the reports and then export them to ...
1
vote
1
answer
2k
views
Extracting data from an excel sheet into another excel sheet
I have a sheet with certain data arranged like this:
X8 - something - something2
X12 - somethingelse - asdfg
X8 - asft - sastaryraavt
X8 - random - random2
I need to extract only and all of the rows ...
1
vote
1
answer
984
views
OpenOffice Calc "if" formula for currencies
I have a spreadsheet that has many different currencies in it ($, euro, shekel). I want to display the actual price in the original currency and then show the converted price (in this case to shekels)...
1
vote
1
answer
183
views
Excel 2013, SUMIFS formula
I think I need to use a SUMIFS function for this but I am not positive. I have a list of codes:
All of these codes are in a category of downtime, each code also has minutes 5,10,15,40,65 etc. My ...
1
vote
2
answers
2k
views
Counter in Excel
My file has 50 sheet inside, which each sheet is a standard form. Lets name as Form1, Form2, Form3.
I want to create a print sheet, where I select which form I want to see, so that I don't need to ...
1
vote
1
answer
4k
views
How to efficiently reference an entire row in Excel?
I am working on a budget spreadsheet in which I have to pull in cell data from another external spreadsheet. I have to do this for several different sheets with massive amounts of data in the sheets, ...
1
vote
1
answer
1k
views
How to perform a function based on surrounding cells in Excel?
My rows on my spreadsheet look like the following:
foo | cherry | 400
bar | lemon | 300
foo | cherry | 500
bar | cherry | 70
I want another row to make calculations in column C based on the ...
1
vote
1
answer
886
views
Sumproduct, Sumif, Indirect and named ranges issue
I have this formula that works:
=SUMPRODUCT(SUMIF(INDIRECT(Financials&"!$B3:$B10000"),'Information PG1'!$K$2,INDIRECT(Financials&"!d3:d10000")))
where Financials is a named range. If I ...
1
vote
2
answers
4k
views
add same value to range of cells in microsoft excel
I want to add the same word from cell B1 to B40000
I do not want to use the click and drag box method to apply it across multiple cells/rows.
I know I have to type in the formula bar B1:B40000 but I ...
1
vote
1
answer
39
views
Replicate a Calculation Sheet for each customer
I created a LibreOffice sheet, with the detailed list of expenses. And a second list with the names and debts of each neighbour.
However, I'd like to generate a personalise replica of the first ...
1
vote
3
answers
355
views
Collect Row # of Matching Elements in Excel
I'm trying to collect the row numbers that match a certain value in multiple columns of an excel worksheet. The behavior I'm looking for reflects the table below:
|---|---------|---------|---------|
|...
1
vote
2
answers
180
views
I hyperlinked a cell in excel 2003, formula issues?
I have a budget spreadsheet using excel 2003. I have My deposit, then all of my bills, the total, then a cell that has the difference(between the amount of deposit and the total of the bills). The ...
1
vote
1
answer
142
views
replace comma separated values in a sheet uses SORT formula to get sorted results from another sheet
I have a sheet called "Form Responses 1" connected with a Google Form, and I made another sheet/tab and used this formula:
=SORT('Form Responses 1'!A2:M, 4, TRUE)
to sort the responses with ...
1
vote
1
answer
939
views
Turn cell references in Excel hyperlinks into the text in the referenced cells
I have a column of bare URLs in Excel. Say it's Column A. I want to replace each URL with a friendly text link, like "here." Suppose A1 contains the link https://www.website.com/content/...