| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Eliminate empty cells in data range
Hi Everyone! I'm using a MIN function to find the lowest value in a set of 10
values that I am downloading from the internet. The problem is, the data will sometimes have an empty cell before the next set of data. I want to find the lowest value of the last ten values. If I just use a range, it will sometimes be 8, 9, or 10 values as the spaces change with the download from the internet? Is there any way to find the lowest number in a set of 10 values if there are empty cells involved? Thank you. -- Thanks! Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I check if data in external data range is changed after re | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
