Hi All - help please!
In the attached spreadsheet, if any of the assets rows 7 to 29 have a number in column K, I would like that information in the relevant row to show in rows 71 to 80 in order.
any recommendations?
Hi All - help please!
In the attached spreadsheet, if any of the assets rows 7 to 29 have a number in column K, I would like that information in the relevant row to show in rows 71 to 80 in order.
any recommendations?
Last edited by azb0105; 08-02-2011 at 05:50 AM.
hi azb0105
find the formula in attatch file.
note that array formula is used and should be confirmed though Ctrl+Shift+Enter
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
Awsome! thanks. It works a treat.
nice
If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks