Adding text boxes on conditions problem

  • Thread starter Thread starter anthony2003
  • Start date Start date
A

anthony2003

Hi Everyone,

I am trying (unsuccessfully) to extract certain information from
worksheet similar to that shown below.

What I am trying to do is to look at a range - in this case D1 to D4
and if any of them match a string (99Admin or AdminSLA) to concatenat
the results from the B column.

EG If I am looking at the D Column for 99Admin the result needs to b
displayed as "Office, Home".
If I am looking at the D Column for AdminSLA the result needs to b
displayed as "Location1, Location2".

A B C D
E
1 09:00 Office 12:00 99Admin 03:00
2 12:00 Location1 14:30 AdminSLA 02:30
3 14:30 Location2 17:45 AdminSLA 03:15
4 17:45 Home 18:00 99Admin 00:15

I have tried various things but I can never get it to display more tha
1 from the B column.

Any assistance would be most welcome!!

Best Regards,

Anthony
 
I'd like to reply to this, but my response would take a long time and is
probably not what you're looking for. I could do this with visual basic I
think, but it would take me a bit of time. I would personally only move
forward if you absolutely had to had 1 cell that contained all those text
strings; if you wanted a column with rows of text strings that would be
easier.

I don't think what you want to do is easy, and you'll probably need visual
basic to get it done. if there is a way with formulas, maybe one of the big
boys can lay out a plan for you.
 
Back
Top