# Search:

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

Page 1 of 2 1

1. ## Thread: Find matching number for the result

by bdtran
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. ## Thread: Find matching number for the result

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Count Repeated Numbers

by bdtran
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. ## Thread: Total Empty column between two characters

by bdtran
Replies
15
Views
453

### Re: Total Empty column between two characters

Thanks Jtakw,

I tested your formula and it worked with expected result.
11. ## Thread: Total Empty column between two characters

by bdtran
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.

BDT
12. ## Thread: Total Empty column between two characters

by bdtran
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. ## Thread: Total Empty column between two characters

by bdtran
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. ## Thread: Total Empty column between two characters

by bdtran
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. ## Thread: Total Empty column between two characters

by bdtran
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.

BDT
16. ## Thread: Total Empty column between two characters

by bdtran
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. ## Thread: Total Empty column between two characters

by bdtran
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. ## Thread: Sort table using function/equation only

by bdtran
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. ## Thread: Count duplicate data row

by bdtran
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. ## Thread: Count data upwards

by bdtran
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. ## Thread: Count data upwards

by bdtran
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.

22. ## Thread: Count data upwards

by bdtran
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. ## Thread: Count duplicate data row

by bdtran
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. ## Thread: Range contains multiple text

by bdtran
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.

*BDT
25. ## Thread: Range contains multiple text

by bdtran
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