How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Kamil Anwar Your Own Question

Kamil Anwar
Kamil Anwar, Computer Support Specialist
Category: Computer
Satisfied Customers: 148
Experience:  8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
69350257
Type Your Computer Question Here...
Kamil Anwar is online now

Formula to extract all unique dates from a list of dates in

Customer Question

Formula to extract all unique dates from a list of dates in date order and present these in a straight line horizontal scatter with dates along the horizontal axis within an excel spread sheet with a description of each straight line to the left. This will be repeated multiple times.
Submitted: 8 months ago.
Category: Computer
Expert:  Jess M. replied 8 months ago.
Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.Can you send me a sample of your Excel data so that I can develop a formula and chart for you? You can attach the file here using the paper clip icon, or you can upload to http://filesXpress.com and then give me the short download link.Please let me know by replying to me here so that I can help you further.Best regards,Jess
Customer: replied 8 months ago.
Hi Jess,Many thanks. Please find the file attached. It's a mess because we have been working with the document.Please call me asap on +44 (0)7845626622.Many thanksDominic
Expert:  Jess M. replied 8 months ago.
Hi Dominic,Thank you for writing back with the Excel file. Unfortunately, I do not provide phone support. I only provide Secure Remote Assistance and this conventional chat method.Please let me check your file, I will get back to you in a while.Jess
Expert:  Jess M. replied 8 months ago.
Dominic,I got your file. Can you please tell me what cell range is exactly you want to extract the unique dates from?
Customer: replied 8 months ago.
Hi Jess,Rows 57 - 174 is the cell range.We are trying to replicate the chart in the link below but replace the bars with blocks corresponding to the unique dates. The blocks may of course merge to appear like a bar but others with fewer dates won't and will appear like a staright line scatter. We do not want the slider above the bars/scatter, just simply the actual date range spread horizontally against each category. The document is to be printed to an A3 sheet in landscape.We have a note to say that for £18 we can increase the service to speak to you. Is this possible?http://cdn.vertex42.com/ExcelTemplates/Images/ganttchart/gantt-chart-excel-xlsx.png
Expert:  Jess M. replied 8 months ago.
Thank you the information. Unfortunately, I do not provide phone support. Please give me a moment to work on this.
Expert:  Jess M. replied 8 months ago.
Dominic,Are you referring to the dates in cell K58 to K174?
Customer: replied 8 months ago.
Hi JessJust running back to my computer but it is all of the columns within those rows. Each column/category will correspond to each seperate line scatter/bar in the chart as shown in the web link.
Expert:  Jess M. replied 8 months ago.
I am very sorry. I can help you in extracting unique dates in the columns but I am confused on what exactly you want to accomplish.Please allow me to opt out so that other experts can assist you further.Best regards,Jess
Customer: replied 8 months ago.
Hi Jess,We are desperate to meet a deadline and need an early ansswer. I wonder if I can better explain as follows:In rows C58 to AD174 we have a number of categories at the top of each column with with dates below (please ignore the additional columns to the right of each with seperate number 1 - 14: this was our elementary attempt to trick Excel into making the chart we want but it didn't work)We are looking to construct a chart like the example show below where each category appears at the start of each row (the y axis) with dates along the x-axis. The dates under each catagory in the data set will be plotted in the chart against each category. Since the y-axis (rows) are based on categories, the chart will appear as a number of straight horizonatal bar/scatter points.Please note that unlike the example in the link, we are trying to plot each seperate date as either a point or a block. Since some of the dates are close together this may appear as a connected line/bar chart at some points.http://cdn.vertex42.com/ExcelTemplates/Images/ganttchart/gantt-chart-excel-xlsx.pngI hope this helps and look forward to your earliest response.Many thanksDominic
Customer: replied 8 months ago.
Note: In our rush to get the question on the Just Answer notice board we believe we may have overcomplicated our question (and the preliminary excel spreadsheet) for what we believe is a simple formula for a technician proficient in Excel. For an early answer we are willing to pay double the normal payment with a tip on receipt of a satisfactory answer ASAP.We look forward to hearing from you.Dominic
Expert:  adamd-mod replied 8 months ago.
Hello there,
I've been working hard to find a Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
Please note, I am just a moderator for this category, I can only try and find experts to help, I can't answer the question itself.
Thank you!
Adam

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Last | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/MI/mikew4950/2011-12-26_1606_mikephoto2s.64x64.jpg MikeW's Avatar

    MikeW

    Computer Engineer

    Satisfied Customers:

    49
    32+ years Computer and Networking Experience
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.