kevin

  1. K

    imported comma seperated data

    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
  2. kweaver

    VBA inserting subtotal(s) rows

    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...
  3. S

    Exporting to Notepad - Select file name?

    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...
  4. J

    Value filtered by and between multiple values in table

    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...
  5. M

    Is it possible to get a Value based on 2 trues ?

    <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...
  6. B

    Return value for 1st, 2nd, 3rd, 4th occurance

    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>...
  7. O

    Macro/VBA Help needed - finding text in column a, if matched return a code

    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
  8. H

    Using the IF function to recreate a whole row

    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...
  9. K

    Question (Quick and simple I hope)

    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...
  10. P

    Count instances in one column based on data in another column

    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...
  11. C

    Audit of data in an excel sheet.

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top