Search:

Type: Posts; User: bdtran; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    155

    Re: Find matching number for the result

    Eric,

    Just got a chance to test your formula with the Excel 365. It worked perfectly with the expected results.

    I really appreciate your help with this formula.

    BDT
  2. Replies
    3
    Views
    155

    Find matching number for the result

    Hello All,

    I encountered a situation that I need your help with a formula to get the result as shown “result” range row J1:X1.

    The calculation based on weekly updated table on the left. If...
  3. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Eric,

    That is awesome! I tested your version and it worked with the exactly result.

    Thank you for your help! very much appreciated.

    BDT
  4. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Aryatect,

    Yes, it worked. I got the exactly result that I am looking for.

    Thanks so much, you saved me a lot of time with this formula. I really appreciate it.

    BDT
  5. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Aryatect,

    Thank you, I tested your formula and got the result in the format as below:

    5.003 3.045 3.002 2.025 2.001

    I tried to change several custom number formats in "0\.000" but could not...
  6. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Mr. Rothstein,

    I changed the format to "0\.0" as mentioned and got the result in the format below:

    500.3 304.5 300.2 202.5 200.1

    Thanks much.
    BDT
  7. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Eric,

    Thank you so much for the helps.

    I got the expected result from your formula but the format of number could cause the problem for my next round of calculation.

    The result format from...
  8. Replies
    14
    Views
    442

    Re: Count Repeated Numbers

    Eric,

    I tested your formulas and both formulas are working into separate cells as mentioned.

    However, I really need in one formula because later, I will need to calculate another result from on...
  9. Replies
    14
    Views
    442

    Count Repeated Numbers

    Hello All,

    I need help with a formula to count the repeating for each number in multiple columns as shown the table in data range A1:X1.
    The result that I am looking for is as in the range Z1:AE1...
  10. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    Thanks Jtakw,

    I tested your formula and it worked with expected result.
  11. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    Jtakw,

    I replaced "A" with "zzz" as mentioned and it returned the corrected result.

    Thanks again with your help.
    BDT
  12. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    Mr. Rothstein,

    I tested both of your solutions for total empty and non-empty columns. I got the exactly result I am looking for.

    Thank you so much for your help on this situation.

    BDT
  13. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    All,

    While checking the data, I encountered a sheet containing the sample data as in the table below. Similarly, I need a formula for the result in row#1 with total of columns (not empty) between...
  14. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    JTAKW,

    I tested your formula and somehow I got the unexpected result as below. Not sure it was on my end error.

    I copied to the A1 as instructed.


    <tbody>
    A
    B
  15. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    Aryatect,

    I used for your formula and got the result I am looking for.

    Thanks much for your help.
    BDT
  16. Replies
    15
    Views
    453

    Re: Total Empty column between two characters

    Special-K99,

    I tested your formula and it worked.

    Thank you so much!
    BDT
  17. Replies
    15
    Views
    453

    Total Empty column between two characters

    Hello Team,

    I need your help with a formula to calculate how many empty column between of the letter “A” as in the row#2. The result that I am looking for should be the same as in row#1 as shown...
  18. Replies
    1
    Views
    239

    Sort table using function/equation only

    Hello All,

    How can I sort a table into another table on the same row in different columns as shown in the example below.

    The sort based on data in the row #2 from high to low (descending).
    ...
  19. Replies
    2
    Views
    210

    Re: Count duplicate data row

    Thank you Dfsobral.

    I tested it and it works. However I just realized that since I have over 20k+ rows which could cause of slowness.

    So instead of copying N1 to the entire column to tell which...
  20. Replies
    4
    Views
    199

    Re: Count data upwards

    James,

    I tested it and it worked with the result I am looking for.

    Is there any way that can be applied the same count for data "Z" and "Y"?

    Also with your code, I have to insert the data...
  21. Replies
    4
    Views
    199

    Re: Count data upwards

    James,

    Thanks much for your quick response. I realize that I also need to count upwards data "Z" and Data "Y" as well as they are inserted in the top row.

    Really appreciate for your help....
  22. Replies
    4
    Views
    199

    Count data upwards

    Hello All,

    I am trying to get the result in column-A and I really need help with a formula to automatically count upwards as I insert data into column-B.

    In the example below I just wanted to...
  23. Replies
    2
    Views
    210

    Count duplicate data row

    Hello All,

    I really need your help with a formula the check the duplicate data row of the specific range as with the example below.

    In column A, I need to check only those rows with the...
  24. Replies
    4
    Views
    201

    Re: Range contains multiple text

    Yongle and Phuoc,

    I was able to get the exactly result I need using your formulas.

    Thanks much for your help.
    *BDT
  25. Replies
    4
    Views
    201

    Range contains multiple text

    Hello All,

    I need your help to create a formula to get one of three results in column A with the following scenarios.

    For example within the same range $B3:$L3, if there is letter "A" found,...
Results 1 to 25 of 33
Page 1 of 2 1 2