0
   

Help on Excel content and realigning

 
 
Reply Mon 9 Mar, 2015 03:02 am

Hi Experts,

I have an excel like below,


Name Status Dates

Record 1 /Saved/Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /01.03.2015/05.03.2015/07.03.2015/09.03.2015/11.03.2015/15.03.2015/25.03.2015
Record 2 /Previous step/My Q/SAved/ Next step /02.03.2015/05.03.2015/09.03.2015/22.03.2015
Record 3 /Previous step/My Q/ Rework/ MY Q/ SAved/ Next step /05.03.2015/08.03.2015/12.03.2015/19.03.2015/22.03.2015/25.03.2015



I want to know when the record has reached my q and when it has moved out of the q and How many days it took before moving out of the q in the fourth column. Sometime the record will have reworks, where the record come back to our Q and will be moved out after validation.



Name Status Date


Record 1 My Q 07.03.2015
Record 1 Rework 09.03.2015
Record 1 My Q 11.03.2015
Record 1 Next step 25.03.2015



or

Name Entry Status Moved out status Arrival to my q date Completed (days)

Name Status Moved to status Date Completed in (days)
Record 1 My Q Rework 07.03.2015 2
Record 1 My Q Next step 11.03.2015 14
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,036 • Replies: 1
No top replies

 
jespah
 
  1  
Reply Mon 9 Mar, 2015 07:13 am
It is very, very difficult to visualize what you're looking for. What does it mean when "the record comes to my q"? Are you talking about the current date eventually equalling another, set date? Are you talking about a queue? Are you talking about changing a record?

The visual you provided is also exceptionally confusing. You will need to show just one or two columns at a time, with only one or two rows. Or, better yet, take a screenshot, post it to an image hosting site like Photobucket and follow the instructions on the image hosting site on how to post an image on a forum.

What you have posted is just a garble of numbers and it is difficult to ascertain what you are truly looking for.
0 Replies
 
 

Related Topics

 
  1. Forums
  2. » Help on Excel content and realigning
Copyright © 2022 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 07/07/2022 at 02:33:35