Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 07-13-2022, 07:51 AM
justa_guy_32405 justa_guy_32405 is offline Not showing Result Windows 7 64bit Not showing Result Office 2010
Novice
Not showing Result
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default 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
Attached Files
File Type: xlsx msofficeforums49335sample_sheet_partial.xlsx (11.8 KB, 5 views)
Reply With Quote
  #17  
Old 07-13-2022, 08:02 AM
p45cal's Avatar
p45cal p45cal is offline Not showing Result Windows 10 Not showing Result Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Would the table at cell I5 do?
Chose your status in cell J3's dropdown.
Attached Files
File Type: xlsx msofficeforums49335sample_sheet_partial.xlsx (15.9 KB, 8 views)
Reply With Quote
  #18  
Old 07-13-2022, 05:20 PM
justa_guy_32405 justa_guy_32405 is offline Not showing Result Windows 7 64bit Not showing Result Office 2010
Novice
Not showing Result
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default 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.
Attached Files
File Type: xlsx msofficeforums49335sample_sheet-3_note_attached.xlsx (14.5 KB, 6 views)

Last edited by justa_guy_32405; 07-14-2022 at 08:04 AM. Reason: A thank you!
Reply With Quote
  #19  
Old 07-14-2022, 11:40 AM
p45cal's Avatar
p45cal p45cal is offline Not showing Result Windows 10 Not showing Result Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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)))
It may not be as short as it could be but I'm having to remember what is and isn't available in your version of Excel.
Once it's working as you want, you can wrap it in an IFERROR function to hide errors.
Attached Files
File Type: xlsx msofficeforums49335sample_sheet-3_note_attached-1.xlsx (14.6 KB, 5 views)
Reply With Quote
  #20  
Old 07-15-2022, 11:22 PM
justa_guy_32405 justa_guy_32405 is offline Not showing Result Windows 7 64bit Not showing Result Office 2010
Novice
Not showing Result
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default 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?
Reply With Quote
  #21  
Old 07-18-2022, 02:25 PM
justa_guy_32405 justa_guy_32405 is offline Not showing Result Windows 7 64bit Not showing Result Office 2010
Novice
Not showing Result
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default 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
Reply With Quote
  #22  
Old 07-19-2022, 03:26 AM
p45cal's Avatar
p45cal p45cal is offline Not showing Result Windows 10 Not showing Result Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by justa_guy_32405 View Post
Last edited by justa_guy_32405; Today at 03:03 AM. Reason: Add file
Not that I can see.


By the way;

'tech' = number?
'wcs' = ?
Reply With Quote
  #23  
Old 07-19-2022, 04:31 PM
justa_guy_32405 justa_guy_32405 is offline Not showing Result Windows 7 64bit Not showing Result Office 2010
Novice
Not showing Result
 
Join Date: Jul 2022
Posts: 16
justa_guy_32405 is on a distinguished road
Default 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..
Reply With Quote
Reply

Thread Tools
Display Modes


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
Not showing Result 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft