I want Excel to find the PUMP ON for me, and then find the previous Tank Level where PUMP OFF. And I want Column O to be automated where I don't have to type " =BXY-BXX" at each instance of Pump On. Then, in Row 66, I have a value in Cell B = 2.479, and Cell N = PUMP ON. Then in Rows 56-65, I have various values in Cell B and Cell N is blank. ![]() For example, Lets say in Row 55 I have Cell B = 2.18 and Cell N = PUMP OFF. ![]() In all rows where Column N = PUMP ON, I want to subtract the Tank Level in Cell B from that row from the Tank level in the most recent row where I have Column N = PUMP OFF. I have a spreadsheet of Date/Time in Column A, Tank levels in column B, and in some of the rows I have an identifier PUMP OFF in Column N, and in some rows I have an identifier PUMP ON in Column N (Pump On/Off was based on whether I had continuous positive or negative numbers in Column B.that part is unimportant). I have what is probably an easy Excel question that is giving me some difficulty.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |