![]() ![]() But I'm struggling trying to figure out how (if it's possible) to calculate the difference. I know to get the "*" in, I'll use an if-then-else statement, which is no problem. I need to find the difference between these two only, such as Test Result #1 and it's pairing with Our Calculation #1 below (within 10% +/- of each other) and mark the top cell in the pair with an "*" after the number already existing in the cell.Įxample: First pair is within +/- 10% of our calculation, second is out of that range. This goes on for about 250 lines, each being "paired" results but in the same column with a skip cell between. I have two rows of data (in the same column), there is a skip cell and then repeat. The girl doing the data entry on it has very little Excel knowledge and is used to things being entered in this layout, so I don't particularly want to recreate the whole spreadsheet. I'm trying to clean up a spreadsheet for my company that was created ages ago. So I've looked far and wide for anything similar and all other people's issues seem to be with numbers in neighboring columns. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |