I have 4 columns of numbers, 1 column is interspersed with blanks, I would like to fill these blanks with the number which is immediately above each set of blanks, I could do this manually but I have about 2000 rows of data, is there a lookup formula which I could use to do this quickly. I've attached a small sample of data.
I love Excel, but I'm not very good at getting my head around formulas!
Last edited by VBA Noob; 02-22-2008 at 05:05 AM.
See link below for your requirement.
http://www.contextures.com/xlDataEntry02.html
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
That's great, thanks Starguy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks