If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Counting Unique Values
Roger,
Ah, that's why you are the expert. (I laughed at my formula after I have seen yours.) I am glad I posted and you responded. Lately, I have been learning about CHAR and I am attracted to it while I have forgotten the simple things in life. g I thought I needed REPT to catch all. I read an example of *adding* trailing spaces and REPT is used. Is it true that we need REPT when adding trailing spaces? Thank you for helping me all the time. By the way, have you read my post about using PivotTable to check for duplicates? Epinn "Roger Govier" wrote in message ... Absolutely no difference to the much simpler =SUBSTITUTE(A1," ","") -- Regards Roger Govier "Epinn" wrote in message ... This is how I would remove trailing spaces. =SUBSTITUTE(A1,CHAR(32),REPT("",255)) Please correct me if I am wrong. Thanks. Epinn "Epinn" wrote in message ... The formulae discussed in this thread should serve Bob's needs. Experts, please confirm that the formulae are only good as long as there are no trailing spaces. e.g. AA111 and AA111__ ( __ are trailing spaces) will be counted twice. If we are really picky, we'll do LEN( ), SUBSTITUTE ( ) etc., right? Epinn "bob" wrote in message ... I have a column with the following dates: 11/23/05 11/23/05 11/23/05 11/25/05 11/25/05 11/28/05 12/1/05 12/1/05 12/1/05 I want a formula that will tell me how many unique dates there are in the column. Can anyone help? thanks, Bob |
Thread Tools | |
Display Modes | |
|
|