Hi Friends,
I need your help to fill the blank cells.
Ex:
A1 1
A2
A3 1
A4
A5
A6 2
A7
A8 2
Result
A1 1
A2 1
A3 1
A4
A5
A6 2
A7 2
A8 2
Regards,
srikanth
Hi Friends,
I need your help to fill the blank cells.
Ex:
A1 1
A2
A3 1
A4
A5
A6 2
A7
A8 2
Result
A1 1
A2 1
A3 1
A4
A5
A6 2
A7 2
A8 2
Regards,
srikanth
1. Select entire column A
2. Press Ctrl + G : Click on Special
3. Select "Blanks" and click ok
4. Enter Formula "=" and upper cell (press equal to sign and upper arrow key)
5. Press Ctrl + Enter
In sperate column i.e. B2 use
Copy down.Please Login or Register to view this content.
then,
Copy and paste special values in Column A
Life's a spreadsheet, Excel!
Say thanks, Click *
Thank both of you for quick repose.
=IF(A2="",IF(A1=A3,A1,""),A2) is not working because gap cells contains value is not consistence.
Ex:
A1 1
A2
A3
A4 1
A5
A6 2
A7
A8 2
Result
A1 1
A2 1
A3 1
A4 1
A5
A6 2
A7 2
A8 2
Aha..
In B1
=A1
In B2 try...
copy downPlease Login or Register to view this content.
Note: last cell in array should be absolute referenced
Last edited by Ace_XL; 11-30-2012 at 08:15 AM.
Try this in B1, Drag/Fill Down
Formula:Please Login or Register to view this content.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you very much.....working greatly......
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks