Hi There,
I'm half way into the supposedly easy calculation, but need some help. I've entered the formula which when equal to "approve" should give me only the details where it matches from another sheet. So if its "approve" then it should give me the name and other details.. I've attached the spreadhseet to make some sense, I need some help here please.
Thanks,
Personally I'd use a Pivot Table and avoid the need for any formulae.
See attached. Since you've only apparently got Excel 2003 I've put the Request Status in the Report Filter area of the PT Field List. If you have Excel 2010 or later it would be more elegant to use the Slicer functionality.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard, Thanks for the help.. I'm not sure why it came up as 2003, im on office 365 so the latest, I know how to use the slicer, but the requestor insisted on some format, which made me use formula only..
Array formula ensure [shift+ctrl+enter]
In "A3"Formula:
Please Login or Register to view this content.
In "B3"Formula:Please Login or Register to view this content.
In "C3"Formula:Please Login or Register to view this content.
In "D3"Formula:Please Login or Register to view this content.
copy down till blank.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Smashing brilliant. I know I'm asking more, but can you break down the formula post small so I understand a bit better. Please
Hi,Originally Posted by nicci113
Your profile is showing Excel 2003. To avoid any confusion in the future it would be a good idea to change it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks