accident

  1. K

    combining count and lookup function

    I would like to perform a count of data, based on the number of times an item is referenced. On one sheet I have the items I wish to count, the data on a second, and the references in a third. My data returns a number for the column i would like to count, but this needs to be 'interpreted'...
  2. T

    Return the value based on the another cells content within that row?

    Hi All I'm finding a solution to this problem of mine some what tricky! Hopefully someone a lot smarter than me will have an answer. I have a spreadsheet that records accidents for multiple sites, 1 row = a new accident Along the row it has a date of the accident in column B, further along in...
  3. C

    Using excel VBA delete multiple lines in a active sheet

    Here is an example of what I have and what I would like to accomplish. <tbody> OPEN WORK REPORT Period NUMBER WORK ORDER DESCRIPTION TYPE 25524484 ACCIDENT accident rollover Period NUMBER WORK ORDER WORK ORDER DESCRIPTION TYPE 25858720 BULK ISSUE Bulk...
  4. S

    How to insert row with increased value after every unique value in column

    Hello from vba newbie I have table with 2 columns: It looks like this: reason code accident A20 accident A21 accident A30 accident-fake A20.0 fake B30 What I need - is just insert values from 0 to 9 to every unique value in column "code". f.e. for A20 - I need to insert 9...
  5. T

    Bring me info from a row that meets certain criteria's?????

    Hi All In my head I thought this would be pretty straight forward, but it quickly became apparent that it's not! What i have is a very big accident log, each row represents a accident entry and has a vast amount of information where i would like to extract certain information into a separate...
  6. L

    Missing parts of pasted formula when when recording macro.

    Can someone please help me? When I copy the formula below(which works) while recording a macro, it seems to have parts of the formula cut off in the code (highlighted below is what the macro creates) for example, the original formula, looks in the data sheet for "highway Tripper", as you can see...

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