# Questions tagged [worksheet-function]

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

**0**

votes

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**1**answer

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

**1**answer

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

**0**answers

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

**1**answer

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

**2**answers

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

**0**answers

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

**1**answer

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

**1**answer

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

**2**answers

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: ...