kevin

I have a sheet that i want to import data to (sheet1 B2) this data is seperated by a comma i want to seperate and create it listed in a single column on (sheet 2 B2, B3, B4 etc) can someone please help with a formula thanks in advance

Before I totally kill my day trying to do this, I thought I'd post this considering how quickly perfect solutions are created. I have a sheet which is already sorted by column H (starting in row 5). [thanks, Fluff] I now need to put in a subtotal row for each group of names in H5:Hn and total...

Hello all! I have the macro below that exports certain columns to a file (in this a m3u8 file). Is there a way I could have excel allow me to type in the file name I'd prefer before exporting? Thanks, Kevin Sub ExportToNotepadOVERALL() Sheets("OVERALL_CLIPS").Select...

Trying to find a way to parse out data when record falls between another record. Example on 12/10/18 - Kevin time is doubled on that day....one foreman entered his time from 8-4 and another foreman entered his time from 10-2. Since it is doubled up, I need to highlight that error. Tried...

<colgroup><col><col span="2"></colgroup><tbody> Client Name Service Orders Kevin Service 1 Orders 1 Kevin Service 2 Orders 2 Kevin Service 3 orders 3 John Service 2 Oeders 1 </tbody> <colgroup><col><col span="2"></colgroup><tbody> Client name Service order Kevin Service 3...

Dear all, could you please help me return different notes for old and new entries considering the date (column A)? I would need for newest row insert note ''valid'' in column C. And for rest - older rows, I would need note ''old'' in column C. <colgroup><col><col><col></colgroup><tbody>...

I have a description coming in from my vendors that not consist. Sometimes I get TKT or Ticket in a cell. No sure which function to use. If c3 contains TKT or Ticket. Then return TKT in d3. Thanks in advance Kevin

Hi, I've tried to make this as clear as I can: (link if the image doesn't work> https://i.imgur.com/Hs2qPg7.png) Riiiight, so here's what I need to do. I need to keep a running total of the performance of our salespeople (the ones in the B column) - How many leads they've been assigned, how...

I was wondering if someone can tell me if Excel has a way to pull a user name from AD using a text box input and an MSGBOX output and if so what the code may be to attempt this? I have attempted it but each time I try to do so I fail and would greatly appreciate if anyone may know the code for...

Based on the table below, I would like to create another table that looks at the names in the left column and counts how many instances the number is greater than 5 in the right column. So the new table would say John Smith's count is 2; Kevin Nance's count is 1, etc. All help is...

Hi There, Hope this is in the right place. Im trying to make an audit of data quick and easy to do in excel. I have a list of reference numbers in a column, the reference number could be in the column twice or three times. Depending on whether its in twice or three times I then want to check the...