• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    find row and column

    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
  2. M

    COUNTIFS with OR

    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...
  3. M

    conditional formating

    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
  4. M

    special subtotal

    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...
Back
Top