Display non blank cell furthest to the right

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Ok, you guys were great on my first post, here's question # 2.

I have a row where users enter data from left to right at various times. Sometimes every day, sometimes not for several days. So one day they enter data in collumn A, maybe next day collumn 2, then maybe not for a weel they enter in collumn 3 and so on. They will always use the next available cell to the right. UP to 8 collumns. How can I make another Cell on another sheet display only the non-blank cell furthest to the right in a specified range of cells?


Thanks again.
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Never mind, looks like my question was already answered by barry houdini in a post by geversud.

Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,114,401
Messages
5,547,740
Members
410,810
Latest member
thepinkbird
Top