electric

Here is my problem: I’m trying to create a macro to find & replace certainrows of text in an Excel worksheet. Example: <tbody> 5710 Electric in Pasture (CLAIM 100%) 0.00 Dr </tbody> Replace with: <tbody> 5710 Electric in Pasture...

Hello I am wanting to write a lookup which will bring back a value based on two conditions. in sheet 1 I want to lookup Group (Column G) and Group counter(column H) and find the long text from sheet 2 column E. (not all of the long text for each group is the same, each group counter can have...

have no idea to set a output of the data ,base on western electric rules 1-4 .because i am thinking to use if else statement to do this, but it can't ,for example western western electric rules 2 must have two out of three over or lower than average value...

I have a spreadsheet set up as: date utility units used cost 7/2/2016 gas 122 $94.86 7/12/2016 electric 98 $100.00 2/15/2017 water 99 $56.87 2/20/2017 gas 120 $122.25 4/28/2017 electric 147...