Hi guys
I'm hoping someone can help as this is driving me nuts!
I'm creating a recruitment tracker and i've almost finished, however I'd like to be able to search on statuses by dates.
I.e. how many interviews happended w/c 29/02/18, how many roles were filled w/c 29/02/18, how many roles were advertised w/c 29/01/18? I've attached a basic mock up to show what I mean - hopefully i'm making sense! Tanks for any help in advance :-)
Excel Example.png
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
And please don't create duplicate threads ... it will waste everyone's time.
The attached workbook employs simple COUNTIFS formulas. For Interviews:Other Status categories would take similar form.
Please Login or Register to view this content.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Thank you so much, could I ask (pic attached) - how would I show how many interviews but against a certaIn project i.e how many interviews did project ABC have W/C 08/01?Excel Example.png
Just add another criteria_range and criteria. If the project is specified in cell I4:Note that inserting a column caused the references to change. This is automatic, and by design.Please Login or Register to view this content.
Last edited by leelnich; 02-01-2018 at 06:05 PM.
Great, thanks
One more question - how could I show the project with the most interviews within a given week AND across the whole sheet?
I used MODE.SNGL in an ARRAY FORMULA* to pick out the most common value in the group:*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.Please Login or Register to view this content.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.
Here is a slightly different approach. I hope it helps. In Cell H6:
=COUNTIFS(E2:E15,">="&H4,E2:E15,"<="&H4+5)
@marketshare, I'm confused. OP inserted a Project column into the table per post #5, shifting a label into cell H6. And without additional criteria, your formula doesn't appear to advance the solution. Am I missing something?
Last edited by leelnich; 02-02-2018 at 12:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks