dave

Hi all, I have an array function that returns text separated by commas (e.g. "Dave, Tom, Dave, Mike...") and it contains duplicates when there is more than 1 match (i.e. Dave). What functions should I wrap around the array to remove the duplicates? Thank you!

Hi, I have the following table; <tbody> A B 1 Alex 60 2 Brad 60 3 Chris 50 4 Dave 60 5 Elli 70 </tbody> I then rank 1 to 5 from highest to smallest. Using =LARGE(B:B,1), =LARGE(B:B,2) and so on down to =LARGE(B:B,5) According to the value of each ranked item in column...

Hello! I've been a lurker for a while and can usually find what I need, but I needed the personal touch with this one so hope someone can help. Pretty new to Index/Match formula, and even newer to Small. To outline what I need, I want to show total hours worked for my guys over all the jobs...

Hey - I'm not sure how to accurately describe this question in the title, but here it goes. I have two columns with data, and one review column. I am looking for help creating a worksheet formula which will count how many unique values in column 2 are associated with the value in column 1...

I dont really know much about excel charts but have been asked to come up with a column chart from some data I have been given. The data looks like this Date Shift Area No Code 6/9/17 John A 5 21 6/9/17 John A...

HI Ok, so lets say i use =COUNTA('MY SELECTIONS'!A1:A100)-1 no problem but lets say the 1 was in cell z1 and the 100 was in cell z2. can it be done and if so how, im goint to kick myself its easy. thanks for looking Dave

Evening All, I would be very appreciative if you can give me some sage advice, I'll do my best to explain. I have a user form with textbooks and comboboxes for "First Name", "Last Name" and "ID Number". I also have a "Search" command button which, when a ID number is entered, will search for...

Hello fellow Excellers, Im new here so hello and here we go and bear with me. I have a spread sheet already with names and values. This is an example real one has (1500 names.) New List <tbody> Name Value Bill 7 Dave 9 Fred John 4 </tbody> I now have an old (yes old)...

Hi All so i use formula like this =COUNTA('MY SELECTIONS'!D:D)-1 But lets say a filtered column D, is there a way th formula would only return the newly filtered data? Thanks in advance Dave