COUNT
Hi, i want to count rows, but only when i write something.
In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
Maybe
=IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
YOU ARE GREAT.
IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
You are welcome! Thanks for the feedback!
Stefi €˛puiuluipui€¯ ezt Ć*rta: YOU ARE GREAT. IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
Stefi, i know this is another question, but, can i make something like google
search? When i write something, the cell to give me a hint? Not really a drop down list, something more like google search bar. i don't know how to explain better. I'm sure you understand. THANKS ALLOT FOR EVERYTHING! "Stefi" a scris: You are welcome! Thanks for the feedback! Stefi €˛puiuluipui€¯ ezt Ć*rta: YOU ARE GREAT. IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
try this
=IF(B2="","",COUNTA($B$2:B2)) and drag it down On Nov 4, 4:56*pm, puiuluipui wrote: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex * * * * * * *A * * * * * * * * * * * * * B 1 * * * *nrt crt * * * * * * * * product 2 * * * * *1 * * * * * * * * * * * * something 3 * * * * *2 * * * * * * * * * * * something 4 * * * * * * * * * * * * * * * * * *nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear.. Can it be done? THANK YOU IN ADVANCE. |
COUNT
THANKS MUDDAN. IT WORKS.
THANKS! "muddan madhu" a scris: try this =IF(B2="","",COUNTA($B$2:B2)) and drag it down On Nov 4, 4:56 pm, puiuluipui wrote: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear.. Can it be done? THANK YOU IN ADVANCE. |
COUNT
Or something like a shotcut.
Database: Central European 265 Central European 75 Central European 365 I have to write Central European. So, i type Cen Eur, and the hint to show me all the words that begins with Cen Eur. Can it be done? Thanks! "puiuluipui" a scris: Stefi, i know this is another question, but, can i make something like google search? When i write something, the cell to give me a hint? Not really a drop down list, something more like google search bar. i don't know how to explain better. I'm sure you understand. THANKS ALLOT FOR EVERYTHING! "Stefi" a scris: You are welcome! Thanks for the feedback! Stefi €˛puiuluipui€¯ ezt Ć*rta: YOU ARE GREAT. IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
Sorry, I don't know such a facility!
Stefi €˛puiuluipui€¯ ezt Ć*rta: Or something like a shotcut. Database: Central European 265 Central European 75 Central European 365 I have to write Central European. So, i type Cen Eur, and the hint to show me all the words that begins with Cen Eur. Can it be done? Thanks! "puiuluipui" a scris: Stefi, i know this is another question, but, can i make something like google search? When i write something, the cell to give me a hint? Not really a drop down list, something more like google search bar. i don't know how to explain better. I'm sure you understand. THANKS ALLOT FOR EVERYTHING! "Stefi" a scris: You are welcome! Thanks for the feedback! Stefi €˛puiuluipui€¯ ezt Ć*rta: YOU ARE GREAT. IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
COUNT
Thanks anyway. Thanks for everything! "Stefi" a scris: Sorry, I don't know such a facility! Stefi €˛puiuluipui€¯ ezt Ć*rta: Or something like a shotcut. Database: Central European 265 Central European 75 Central European 365 I have to write Central European. So, i type Cen Eur, and the hint to show me all the words that begins with Cen Eur. Can it be done? Thanks! "puiuluipui" a scris: Stefi, i know this is another question, but, can i make something like google search? When i write something, the cell to give me a hint? Not really a drop down list, something more like google search bar. i don't know how to explain better. I'm sure you understand. THANKS ALLOT FOR EVERYTHING! "Stefi" a scris: You are welcome! Thanks for the feedback! Stefi €˛puiuluipui€¯ ezt Ć*rta: YOU ARE GREAT. IT WORKS! THANKS. "Stefi" a scris: Maybe =IF(ISBLANK(B2),"",ROW()-1) in A2 (although this is not a real counting, it's only showing the row number of filled cells in column B). Regards, Stefi €˛puiuluipui€¯ ezt Ć*rta: Hi, i want to count rows, but only when i write something. In column A i want the number to appear when i write something in column B ex A B 1 nrt crt product 2 1 something 3 2 something 4 nothing When i write something in B2, i need number 1 to apeear in A2, and start counting in A3, A4,...etc, but only when i write something in the next cell If i delete B3 or another filled cell in column B, the count to dissapear. Can it be done? THANK YOU IN ADVANCE. |
All times are GMT +1. The time now is 04:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com