Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [worksheet-function]

Questions about using in-cell functions/formulas in spreadsheet software.

0
votes
2answers
20 views

subtracting the hours from a total of hours granted

I have difficulty in subtracting the hours worked (column B), from a total of hours granted (Column A) A simple subtraction between the two cells does not produce the desired result, probably because ...
1
vote
1answer
13 views

Remove column names from formulae (Convert into regular cell coordinates without sheet names)

I have a defined table of several rows and columns containing data and formulae. Some of the columns' cells' formulae are: =[@[Weight]]*1000 Where 'Weight' is the name of a column heading. I want ...
0
votes
1answer
12 views

hiding rows based on a cell for multiple worksheets

I have a folder with multiple worksheets each sheet is for a separate date. I want to hide rows based on the cell information in F5. I have managed to get this working for one sheet but not multiple. ...
0
votes
0answers
15 views

Sum a range if value matches criteria where the range is produced using the intersect operator

In my specific case, I'm trying to sum only positive numbers that fall within the intersection of my named ranges. However the intersect operator does not appear to work with the SUMIF function. =...
0
votes
1answer
29 views

Excel changing the row reference in a formula

I have the formula "=k6+h7" in the cell K7, I would like to have excel calculate the new cell number when I delete a row. The formula is populated in all the K column cells.
1
vote
2answers
78 views

how indicate the company that made the lowest offer?

I have an excel sheet, where there are three companies with the related offers. With a formula, I calculate the lowest offer. How can I indicate in another cell, the name of the company that made the ...
0
votes
1answer
30 views

Deleting Repeated cells

I am comparing 2 columns in WPS spreadsheet using the 'Highlight Duplicates' option. Once it is highlighted, if I use remove duplicates it isn't deleting the duplicates. If i manually delete the ...
1
vote
1answer
15 views

How to format an Index lookup number into minutes

I have a Cell where i've used an Index lookup to pull a number from another sheet, (ie 5) this represent the number of minutes something takes to do, but for it to work in the current sheet, it needs ...
0
votes
0answers
15 views

How to arrange results of Spreadsheet Compare

I am using "Spreadsheet Compare" provided by Windows/Microsoft to compare two Excel workbooks. It does the job for me. It highlights the differences, but when it posts the results it does it in one ...
0
votes
1answer
19 views

What formula to extract multiple rows from a report using a specific cell criteria

I have a biweekly report of open orders and need to create separate file for each employee. I do not know how to extract the range of cells based on the employee name. This is the similar to the ...
1
vote
2answers
34 views

Dynamic Arrays for earlier Excel versions

Is there a way to have an array formula "spill over" in earlier Excel versions? I have heard that the new Excel will bring dynamic arrays, but need this functionality on an older version of Excel. I ...
0
votes
0answers
16 views

Excel shared spreadsheet, iPhone changes appearance of CHAR function

I have an Excel 2016 spreadsheet which I want to be able to edit on my iPhone as well as my laptop. I've set up certain cells to display a tick/cross if a certain thing is done or not using the CHAR ...
-1
votes
1answer
32 views

Excel in Windows 10

In my target cell I want to subtract the numeric value in one cell from another cell's numeric value - but if one of those two cells contains a zero value, or if it contains the text "ongoing", I do ...
0
votes
1answer
32 views

Auto-Refresh RSS Feed in Excel

I added an XML source using the Developer tab on Excel to load an RSS feed onto Excel. I wanted to make Excel automatically refresh the feed every 30 seconds, however, when I go to the Data tab to ...
0
votes
2answers
114 views

Make the sum in a text type cell of Excel

This question concerns Excel. If I have a cell of type text, in which I go to insert more dates with hours for each date, formatted as follows: 06/05/2019 Hours taken: 1,23 06/09/2019 Hours taken: ...

15 30 50 per page