narrative

<tbody> A B C D E F 1 Name Date Time Incident Type Written description Action taken 2 Emma 05/08/19 14:00 Environmental I was walking across site and saw water gushing out of a pipe near the sheds at the back of the houses. Quite a large puddle had already deveoped and it...

Hi, I am trying to automate a way of searching through my bank statement and returning a reference number based on the narrative that appears on the statement (sample data attached). We get hundreds of items every day and the narrative that is quoted on the bank statement is always different...

Have tried (and googled) this before without success so here goes. Rough example: I have a number of projects with a filter applied at ROW 4, what is the formula in C2/C3 that will generate the totals when the filter is active? Thanks in advance Kev <tbody> A B C 1 Narrative Totals...

Hi All, I'm hoping someone may be able to point me in the right direction with this. I have some code which filters data and subsequently creates individual spreadsheets using the filtered data. I am using a range to help inform my file name when I save the newly created spreadsheet, but I...

I am writing a narrative for our template and the number that needs a comma is in the middle of the text. How can I get excel to insert the comma? EXAMPLE: =CONCATENATE("There are ",TB1FluidsB2," gallons of fluids contained inside of the berm.") Needs to read: There are 69,826 gallons of...