Posted to microsoft.public.excel.misc

TUF

external usenet poster

Posts: 8

Find last entry in a row

HI,

I have rows of figures under monthly categories, i.e. Jan, Feb, Mar etc. . ,
there are empty cells within each row (approx 18 columns wide).

What I am trying to get is a formula that reads the last entry in the row
even if there are empty cells on either side of it

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible sumproduct to find/sum the last entry in each row	Sarah (OGI)	Excel Worksheet Functions	2	April 22nd 08 09:52 AM
Formula doesn't find last entry	caj	Excel Discussion (Misc queries)	3	September 25th 06 07:34 PM
FIND THE LAST CELL ENTRY IN A ROW	Carolyn Bennett	Excel Worksheet Functions	7	January 18th 06 05:51 AM
FIND - Double entry	Danny	Excel Worksheet Functions	2	September 20th 05 08:05 PM
How do i use vlookup to find more than 1 entry	Shaum	Excel Worksheet Functions	3	March 18th 05 04:49 PM

All times are GMT +1. The time now is 12:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us