Get the Dates

Status
Not open for further replies.

anneb_87

Board Regular
Joined
Jun 13, 2018
Messages
52
Hi Experts!

I need to get the deadline of the following client:
Client Deadlines
A
B
C
D
E

The source data looks like this:
Deadline 10th-15th 16th-20th 21st-25th
Blank ClientA ClientB ClientC
Blank ClientD blank ClientE

What should I do??

And how do I insert a table here in the message box? so that my question is more clear
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,194
Office Version
365, 2010
Platform
Windows, Mobile
And how do I insert a table here in the message box? so that my question is more clear
See the link below

Attachments

Please note that this is liable to change once the board update is done later today.
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,194
Office Version
365, 2010
Platform
Windows, Mobile
I'm afraid not by what you have in the first post.
 

anneb_87

Board Regular
Joined
Jun 13, 2018
Messages
52

ADVERTISEMENT

Can anyone help me on this?
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,194
Office Version
365, 2010
Platform
Windows, Mobile

ADVERTISEMENT

@anneb_87, I think you will have to update (well create a new one in the reply) your table from post number 1 to get any replies.
To do this see the link in my signature block for usable screenshots. Try not to use the Upload image button as we can't copy/paste it to Excel so it will also lower the responses that you get.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows
Thread closed as it has been continued here.
 
Status
Not open for further replies.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,170
Messages
5,509,577
Members
408,744
Latest member
leen1234

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top