Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |