|
Why not set last_cell to be the actual cell and then use last_cell.address ? Phone posting so I haven't tried the code, but I'd expect that the issue comes from assigning a cell address directly to a variable which might not result in the expected type of string... Edit: After quick test the above doesn't seem to be the case, cell.address seems to return a nice boring string in A1 format with dollars. Shazback fucked around with this message at 16:51 on Feb 17, 2022 |
# ¿ Feb 17, 2022 13:58 |
|
|
# ¿ Apr 27, 2024 17:09 |
|
If you just want to check for an item in a cell [A1] that there is at least one match in a column [B] : = Countifs( B:B , A1 ) > 0 This formula can be extended down (to replace A1 by A2 in the calculation in the next line) or expanded (if you have other criteria to determine if a row should be true or false), and if you want to match an exact number of times you can just change the equivalence at the end (exactly one match being " = 1 " as you'd expect). Is this what you were looking for?
|
# ¿ Mar 3, 2022 08:32 |
|
double nine posted:is there conditional formatting formula that allows for For example from row E4: = And( modulo( Row(E4) , 2 ) , E4 > 2 )
|
# ¿ Mar 20, 2023 12:50 |