Calculate using the next available number

[clintonmadden]

Hi,

I've been making a spreadsheet to show costs per division then taking the cost +VAT from the budget however the divisions aren't making their purchases in order and my spreadsheet returns a #VALUE! error. Is there a function I can use that will use the next available number in a column?

Thanks for any help you can give,

Clinton

 

[Alc]

I've only recently started using it myself, but have a look in the Help section for the INDEX function. I think that might be what you need.

In my case, there's a series of cells in rows 3 to 15 and I want to put the lowest value (physical, not in value) in another cell. I use the following formula in the cell to be populated and it seems to work for me.

=INDEX(C3:C15,COUNT(C3:C15))

 

[clintonmadden]

Thanks for the information, I'll have a look when I get a second, I've been given a load of high priority work to do lol. But then whatever anyone gives me, it always seems to be high priority...more like work people don't want to do themselves lol