Good Evening!
I am trying to get the field N49 to automatically populate the date that corresponds with field P49.
The field P49 already populates and updates as necessary from this separate spreadsheet.
Any thoughts?
Good Evening!
I am trying to get the field N49 to automatically populate the date that corresponds with field P49.
The field P49 already populates and updates as necessary from this separate spreadsheet.
Any thoughts?
Last edited by robbys15; 11-24-2014 at 10:09 PM.
Where are my manners... Thanks to any/ all who can assist! This spreadsheet is stressing me out!
Capture 1.PNG
A better way to look at what I am trying to do. I would need the date value to populate and update with the #1 position. So this would be 1/3/14. (the time is a luxury that I don't need, but would like ) If it were kicked out of the #1 spot to #2, then everything would update appropriately. Thoughts? Thanks again for looking!
Last edited by robbys15; 11-24-2014 at 10:46 PM.
Hi
Could you upload a simple sheet to work with?
Book1.xls
Please see attached.
Hi
I have attached a sheet that might solve your problem...
It is an array so it will need to be entered with cntrl-shift-enter.
Hope it helps
Regards.
Last edited by Bobsone; 11-24-2014 at 11:21 PM.
You sir, are a god! Thank you so much! I greatly appreciate it!
Glad it helped
TEST TEMPLATE.xls
Good Evening... Again. I come back for one last request. It seems I need a time frame to populate as well :/. Also, I am looking to find the highest count for a specific date. When the date changes, it needs to pull the highest count for that date. Again, thank you for your assistance and help! I greatly appreciate it!
Hi
I think it is done...
All of the formulae I have loaded are arrays (Cntrl+Shift+Enter).
Regards.
Last edited by Bobsone; 11-26-2014 at 07:39 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks