#16
|
|||
|
|||
Thought I had.. rushing around
I thought I had, I do apologize, wearing 4 hats now-a-days gets old..
"A" looks fantastic..and honestly as You point out with the red notations, I was looking to the right of the cells... I attached that file I may not get to reply for a while have to be down at the yard by 1030 |
#17
|
||||
|
||||
Would the table at cell I5 do?
Chose your status in cell J3's dropdown. |
#18
|
|||
|
|||
Drifting...
Update: p45cal I really appreciate the assist with this! The pivot table should work. I am going to hand it off to someone else, that has the time to sit and interact with it. My ability to really sit down and look for/progrm/evaluate solutions isn't manageable. 10 years ago I lived and breathed btk.
Last edited by justa_guy_32405; 07-14-2022 at 08:04 AM. Reason: A thank you! |
#19
|
||||
|
||||
Try this in cell G6, copied down. It may need to be array-entered in Excel 2010.
Code:
=INDEX('Sheet 2'!$D$1:$D$1000,SMALL(IF((('Sheet 2'!$B$3:$B$14=$F6)*('Sheet 2'!$C$3:$C$14=$M$4))=1,ROW('Sheet 2'!$B$3:$B$14)),COUNTIF(F$6:F6,F6))) Once it's working as you want, you can wrap it in an IFERROR function to hide errors. |
#20
|
|||
|
|||
It worked!
Flawless! an absolute whiz.. I can't thank you enough! I emailed the solution to the young'n at the desk.. I couldn't put it down this evening myself.. I might actually have a weekend! Is a credit url linking back to your profile here good?
|
#21
|
|||
|
|||
I you have a minute.. same subject, a reference lookup
It dawned on me over the weekend that the new functions would be moot because the actual status wouldn't be tracked in the sheet, so multiple copies open and reqs coming in would still leave the possibility of 1 tech getting returned on several instances in a wcs.
I made a new sheet [Status] an exact dup of sheet 2 it will monitor the status of sheet 1 [Assign] and sheet 3 [Tasks]. =IFERROR(VLOOKUP(E1,Tasks!$C$2:$E$14,1,"S"), IFERROR(VLOOKUP(E1,Assign!D6:$D$112,1,"R"), IFERROR(VLOOKUP(E1,Assign!G6:$G$112,1,0),"A"))) I don't get any errors and the wizard shows results in the pointed out spots. Any clue? Last edited by justa_guy_32405; 07-18-2022 at 07:03 PM. Reason: Add file |
#22
|
||||
|
||||
Quote:
By the way; 'tech' = number? 'wcs' = ? |
#23
|
|||
|
|||
Wcs
wcs = worst case scenario.. habit.. Yes the tech was the number.. I found the problem.. The column inserted into the status sheet to track the current number value returned in the G column you supplied.. was canceling everything out. Since the task is back to me, I can take a little time and roll the process around my head. It's unlikely any 2 or more people will be entering info at the same exact moment. I might explore a connection to a sql db to connect the web forms and the sheets to, or vb to directly write and read the csv file..
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pulling data from MenaData and BioData in result sheet based on employee id and then result in resul | aligahk06 | Excel | 2 | 09-07-2019 02:23 PM |
Data Compare and result as true or false in result sheet | aligahk06 | Excel | 1 | 08-29-2019 06:44 AM |
One Cell that controlls spread sheet result button to change simple fomula result | RAH | Excel Programming | 5 | 03-31-2018 04:52 PM |
Outlook 2013 Gmail IMPA emails not showing dates only showing times | zillah | Outlook | 0 | 12-21-2017 01:20 AM |
email there but not showing in inbox, notifications showing | bbxrider | Outlook | 0 | 05-15-2017 11:46 PM |