Hello friends, Hope all is well!
I need your kind help please. Ignore all the sheet, and let us only focus on L & Q.
L cells change, sometimes are either blank, or have a month name.
I want the Q range to show the values INORDER from the L range (without BLANK).
your kind help is needed and appreciated, always!
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
great! thanks, but cant it be done with a formula instead?
Sir karedog its array i like it
@countryfan_nt :
You are welcome.
Array formula on cell Q8 :
Formula:
Please Login or Register to view this content.
@daboho :
Thank you sir
A true Guru! Terima kasih
Sama-sama, terima kasih
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks