• 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. B

    Matching between two ranges, which also have values that repeat several times.

    Hello friends, In columns k and l, a solution appears row after row, both give the same result, I am asking for one formula that will give the solution,Non-volatile and non-concatenated. Thanks, David
  2. B

    How to sum values in excel until they reach a specified sum?

    Hi, I copied up to line 30, keep copying until the end. David
  3. B

    Random Pairing with 2 variables

    Hi, Open a new thread, upload a file, and give two examples in the file, which solution you are looking for. David
  4. B

    Random Pairing with 2 variables

    Hi , {=(A2:A7<>TRANSPOSE(B2:B7))*1} I uploaded the solution in the file, and also the solution through a matrix, copy it into the file. And you will see the pairs you are looking for, the formula of the matrix is in cse.
  5. B

    Random Pairing with 2 variables

    Hi, What version of Excel do you have?
  6. B

    Random Pairing with 2 variables

    Hi, There are 33 possibilities. =SUMPRODUCT(COUNTIF(A2:A7,"<>"&B2:B7)) David
  7. B

    How to sum values in excel until they reach a specified sum?

    Hi Aamir, To understand exactly and give you a solution, take only 100 rows, and give an example of a range of 1,2,5 manually, how exactly do you want the solution to look. And what version of Excel do you have? David
  8. B

    Excel find which group of nunbers repeating in multiple columnes

    Hi shrivallabha, I would like to make it clear that the data in the columns are unique data, and are not repeated more than once. If it were otherwise, then of course a different formula is needed. David
  9. B

    Excel find which group of nunbers repeating in multiple columnes

    Hi shrivallabha, Also check this version, =IFERROR(AGGREGATE(15,6,(1/((COUNTIF(B1:D23,A1:A23))=3))*A1:A23,ROW(A1)),"") David
  10. B

    Excel find which group of nunbers repeating in multiple columnes

    Hi shrivallabha, Upload the example you mentioned and we will check. David
  11. B

    Excel find which group of nunbers repeating in multiple columnes

    Hi, In F1, formula copied down. IFERROR(AGGREGATE(15,6,(1/(INDEX(COUNTIF($A$1:$D$23,$A$1:$D$23),,1)=4))*$A$1:$A$23,ROW(A1)),"") David
  12. B

    Sort in two columns

    Hi Peter, Very nice ! Thank you!
  13. B

    Sort in two columns

    Hi p45cal, The lambda function is foreign to me, I haven't found time to learn, I hope to devote more effort to it. Thank you very much for your help. David
  14. B

    Sort in two columns

    Hi p45cal, Can you upload the file with the example you showed(sortrange)? Thank you
  15. B

    Sort in two columns

    Hi p45cal, I asked for a solution with a sorting function. I'm quite afraid that there is no solution, with sorting functions. Thank you !
  16. B

    Sort in two columns

    Hello friends, I want you to sort these two columns, 0 0 0 2 0 4 0 6 2 0 2 2 2 4 2 6 4 0 4 2 4 4 4 6 6 0 6 2 6 4 6 6 The minimum will appear in the first column, and the maximum in the second column...
  17. B

    COUNTIF not containing #N/A

    Hi @Fluff13 , To know where the mistake in the construction of &"<>#N/A"
  18. B

    COUNTIF not containing #N/A

    Hi @Fluff13 , I know that, it's possible too =SUM(INDEX(COUNTIF(B1:B11 ,IFERROR(D1:D11 ," ")),0)) or with IFNA. Thank you
  19. B

    COUNTIF not containing #N/A

    Hello friends, Does anyone know a way to avoid calculating #N/A cells? =SUM(INDEX(COUNTIF(B1:B11,D1:D11&"<>#N/A"),0)) ,does not work , The correct result is 12 Thanks for the helpers David
  20. B

    COUNTIF for blank cells

    I found, when the way the way is simple, and looking for the crooked way =SUM(COUNTIF(B2:B43,D2:D43&" "))
  21. B

    COUNTIF for blank cells

    Hello friends, Does anyone know a way to avoid calculating empty cells? The range is fixed, the data changes, and there are empty cells, These formulas do not work properly =SUM(COUNTIF(B2:B43,D2:D43&"<>*")) =SUM(COUNTIF(B2:B43,D2:D43&"<>")) =SUM(COUNTIF(B2:B43,D2:D43&"*")) Thanks for the...
  22. B

    Ho to RANK Non-Continuous Range In Excel

    Hi Upload a file, and specify the expected results. David
  23. B

    Need If Formula

    Are these parameters correct? Amount Commission min max 50,000 10.00% 4,000 4,000 2,000,000 6.00% 6,000 6,000 5,000,000 5.00% 7,500 7,500 10,000,000 2.50% 10,000 10,000 100,000,000 1.50% 15,000 30,000 David
  24. B

    Need If Formula

    Hi mohammad, If you put the expected commission, from the amount, which is clear enough, I assume you will get a flexible formula. David
Back
Top