accident

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

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

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

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

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

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