ok all. I'm in a bit of hot water with my wife. I promised her I could get this to work and so far I've run into a brick wall.
I need a Reference formula to lookup dates(Within Range) that a specific employee is working.
ok all. I'm in a bit of hot water with my wife. I promised her I could get this to work and so far I've run into a brick wall.
I need a Reference formula to lookup dates(Within Range) that a specific employee is working.
I am pretty sure this is completely possible
However, to avoid mis-communication here, what EXACTLY would you expect to see with the Info on your sample?
If it's to hard to explain, put a few hand figured examples on your sample, it gives us something to check our answers with as well, I HATE offering a solution that misses what you want !
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Ok, I've updated this sheet with Comments and a sample data return line
OOH...it is a bit of a complex one isn't it....
this may take a bit, so be patient please
Any chance of same person working two shifts in one calendar day?...complcates things, but need to know if this is even going to be near accurate first time around...already starting to get lost...LOL
Yes, One Person could theoretically work all 3 shifts(Notice there is either a name or a "X", I would like the "X" to pull availible shifts.
"X"?
this does not appear in data or original post...what EXACTLY do you want from this question?...it started as a lookup of (basically) what shifts did (employee name work, as what,what dates) work ...now it's turning into???
Id' rather you started out will all the information, rather than "we'll start here, then add this, then add this..." the formulas for first question may, in the end, have ABSOLUTELY nothing to do with what you really want...so please tell me where this "X" condition has appeared from?
Sorry, busy night for the kids. Don't worry it's not an additional variable. I'm simply using Employee X to enable my wife to look at open shifts she needs to fill. That Schedule actually goes out to April of 2014. I really appriciate the help on this one. I've been trying to get this done for her for the last 6 months.
okay, would your wife be amendable to a "HELPER" sheet ?
, which can be hidden, this single cell array formula is driving me insane because of the way the data is set up...using helper will speed up the lookup, the processing, can lead to a pivot table approach (which sounds like what you really need here, I just can't make one work the way the data is sorry), but it would in general speed up things...??
Edit-
I am 4 rows into the formula bar, and just starting to get results (WRONG, too) so I definitely hope this approach works...lol
Last edited by dredwolf; 02-05-2013 at 03:28 AM.
Priority #1-it works
Priority #2-it looks the same
Other than that she's be happy
Still working on it...
Still working on it, but this can never be 100% accurate, very little of the data in the schedule (oooh...say... the employee names), actually matches the stored data (..Employee list...), the abbreviations, concatenations, added #'s, etc. make this Data Almost impossile to work with..on the first date in the schedule I have one name impossible to resolve to a single person, and a second that in reality should come as impossible (Mag being the impossible one, Yolanda being the one that should be, only reason Yolanda resolves is because there IS an exact match for the name alone...)
The abbreviations used are inconsistent, multiple people working same shift as same job....HOW does your wife expect you to create a sheet to lookup a certain person, on certain dates, when you can not even be sure the(possible) match is right???
Sorry, but I don't think this is going to fly, will keep working on it for awhile, but unless the data your working on becomes more uniform, I do not see an easy/possible resolution to this
Last edited by dredwolf; 02-07-2013 at 02:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks