Search results

Hi all, thanks. It helped me a lot. :-) Michal

Hi Suresh, I changed it to correct syntax (according your message), but it again does not work, what if value, that I need to find is not in column A, but in column D. (note: value, that I need to find, is in column A, than it works, but value, that I need to find is in column D). thanks...

Hi Juanito, thanks, I tried to do that, but it gave me NA =ROW(INDEX(A1:H5,MATCH(K1,A1:H5,0))) what I am doing wrong? thanks. Michal

HI Narayan, thanks for help, it is working perfectly. thanks :-) Michal

Hi all, I would need help, I have an array A1:H5 with unique names, I need to find one name in this array and I need to know column and row where this name is "sitting". thanks for help. Michal

Yes, you are exactly right, but right now my counifs has 1,5 line (more criterias), If I would need 6 parameters in OR function, than my formula would have 9 lines, I wanted to avoid this - if possible of course, if not, then I will use solution - you mentioned. In any case, thank you for help...

Hi, have you ever met with this king of problem? I am using a countifs function, but in one "criteria" I need to built in "OR" function, I am trying to put to the "criteria" field: OR($F$22,$G$22), but it does not work. What I want to achieve is, that my criteria range is compared with two...

OK, in first column (C_column) there is a formula, result is in %, in a second column (D_column) there is also formula with result in %, then in Conditional Formatting Rules Manager: applies to: =$C$37 (right now I am in a row 37), In "Edit Formatting Rule": type: Format all cells based on their...

can I send you an email with attach? thanks

even when I copy paste special, second line compared value with first row :-( What I am doing wrong? thanks

yes, I did it before (deleting of dolar), but message "you cannot use relative references in conditional formating crireria for color scales, data bars and icon sets" appeared.

Hi, could somebody help me? I have a two columns with numbers and I need to condition format my first column based on value in second column, in rows a different values, I am able to set conditional formation for each row separately, but I have too many rows ... thanks for help. Michal

Yes, perfect, that works, thanks. Michal

HI, thanks, I used the formula, but the result is always same, although I am changing filter..., what I am doing wrong?

Hi, I have a question, I have a list of agents (first column) with team leaders (second column) and with let's say letters: a, b, c, d (in a third column). I need to count how many "b" letters are there, but with filter turned on second column: e.g. Team_leader_1. thanks for your help, regards...