Search results

Sorry, I took the wrong Dutch version of Substitute. Everything is fine. THANKS!!!!

sorry, this does not work on my test in my example there are 8 comma's. I need that number (8) subsitute in the format you write does not work in muy Excel version (20120) Bob

Hello anyone, I have a large text with a number of comma's in it. (i.e content of A1 = M1,2,3,4,5,6,aaa,bb,cc) How can I count the number of comma's (thought NOT the number of total caracters of the text, but how many times is there a comma (of whatever caracter) in the text?) Of course I can...

Hi all, is it possible to track the person (user) who changes a cell in Excel, ie. cell B2, user Jon, changed 2012.07.04:15:12 Thanks for responding. Bob NL

Thanks Luke M, but is does not fill up empty spaces; I mean to produce an extra colom with 10 items instead of the original 23 and filled up from the top. It is almost the same as making a pivot and then copy the product. I know that procedure of course. Bob, NL

Hi all, I have a colom with in some cells an issue (see below, 0 - zero- means no content How can I copy only those cells that contain something (A) to a new colom (B)? Col A - Col B aap - aap jet - jet 0 - kokos kokos - mies mies - moeder moeder - paard paard - willem willem...

Hui, Yes, you are right about the function, it should look like this if (Subtotal(109, R1:R2)=0; dot this;do that) but it never sees 0 (zero) when the count is 0 (zero) This I can control by using Code() of the cell. When the count = 0 (zero) the code is 49 instead of 48. So I see 0 (zero)...

Hi, you should create one Main WorkSheet; import the various data in different Tabs (different years - easiest way for maintenance) Then put the data in one large sheet (#2 after #1 etc.) and then create your pivot. Later on, if you are familiar with this workaround you can import directly from...

Hi all, I use the function Subtotal(range; range) most of the time. If the count = 0 (zero) I want to do something; if not do something else. So that should be simple: if (Subtotal(R1:R2)= 0 do thing1; do thing2) but..... the IF function never sees 0 (zero) but instead of this 1. I tried...

umer, collect data in a row-way; not in a pivot-way Country count Categorie japan 45 MILK Holland 21 MILK USA 332 MILK UK 33 MILK japan 912 BUTTER Holland 52 BUTTER USA 246 BUTTER UK 35 BUTTER japan 3 HONEY Holland 32 HONEY USA 36 HONEY UK 3 HONEY Som van count Kolomlabels...

Thanks Luke for your reaction; I am using excel 2010 and 2007 as well, but do you mean Alt zero,s or Alt O, to go to the Format Styles dialogue? Neither seems to work in my table. Bob

Hi Guys, I am using the set as Table format to obtain zebra lines in a workbook area; that goes fine. But: how can I reset the table format to normal (= no format)? I'm overlooking something perhaps but I do not see what. Thanks for your help. Bob, NL

Dan_I Thanks, thats works the way I needed. Bob, Hilcom NL

Hi dan_I, thanks for your reaction, but how do I create the data validation list? I cannot find the way to define this list in the particular cell. I seem no activeX controll. Bob

Hai, I downloaded your example of the Simple to-do list; it works ok. Can you tell me how to construct the pulldown box (Done, Not Yet) that fixes in the cels A2,A3....? I can read the macro code but cannot find the definition of this object. Bob, Hilcom NL

30-12-2010 Although a table format is working nice it must be possible to choose only <visible lines> by selecting properties or something like that. Disadvantage of the table formatting is that it means a fixed number of lines and that is what I do not like. When I filter say, 1000...

Thanks, this works indeed Bob

We already saw how to make zebra lines (conditional formatting) Now I want to filter records in a certain colom and still have remaining on/of zebra lines. The formula using =mod(row();2)does not work because it takes alle rows, not only visible. Anyone? hilcom - Bob, Netherlands