Search results

Thank you so much, this works, but ... This ranks them 1,1,1 4.4,6 etc. Is it possible that they are ranked 1,1,1,2,2,3, etc? I hope that makes sense ... Rodger

perfect, thank you!!

this is so simple, sorry, but I am doing something wrong what I need: I have a column of true/false - if all in the column are false, it returns ''x'' if one or more are true, it returns ''(blank)'' I am using =COUNTIF(AC!$R$39:$R$52,"<>FALSE")=1 this only accounts if one is different, I need...

I am trying something new, and need help. I have Column C with a YTD total. Is it possible to have Column A rank the players, IE: 1, 2, 3-T, 3-T, (if they have the same total), 4, etc

=COUNTIF(A1:A100,"<>"&"") specify your range

see if this is any better.

something simple like this ?

As a suggestion, I use a button to 'confirm entries' which then locks them. Also have the entries lock upon exiting the entry tab.

It is because you are using the absolute references (dollar signs), so it wont change the cell references when copied. see attached for correction. Cheers

Hi Guido, Bingo! thats it. Thank you so much Cheers !

Hi Nebu, Sorry, I was looking for data validation to not allow a duplicate, unless it is the same value as the cell above. Thanks for looking !

Hi all, This seems to easy, but I can't get it to work. I would like to prevent duplicates in a column, unless it is in the cell directly above. So, in essence, you can enter the same text twice, or more, so long as they are grouped together. I am trying something like...

Fantastic ! works like a dream. Thank you VERY much - this solves a lot of problems. Cheers! Rodger

Hi, thanks for taking a look! I put your code in, and it gets hung on the first line after Then .Range(Cells(x + 3, c), .Cells(256, c)).Copy whether I use it in the sheet code, or separate module. any thoughts? Rodger

Hey Gurus! Any idea why this code works perfectly inside of a module, but not if i put it in a GoSub / Return routine in a sheet code? It cycles thru the sheets, but does not perform the For/Next functions. As I say tho, if I call the module with the exact same code, it works fine. Months =...

Hi Marc Thanks for the input! It will be the user entering the data, and I'd like it foolproof in case they dont skip a row when entering, and for other portions of the program, there needs to be a space between categories. I will take a look at your code when I get home later. Much...

Thats great Hui ! Thanks again for your time. Cheers

Hui, thanks for taking a look! This works great (here comes the dreaded 'except") Except I didnt think to mention that the other columns have formulas, and this is clearing them out. Rodger

Hi All ! Im baffled, so I am turning to the gurus. I am looping through cells D1:D250. When there is a non-blank cell, I wish to copy from that row down, columns D to K, and paste it down one row, in the same columns. In essence, creating a blank row above it. **The idea is to create a space...

Excellent, got it! Thank you both! Rodger

I've tried everything, but alas, off to you experts ... I'm looking for a code so that when any cell in a row is the active cell, the cell in Column B for that row will be highlighted, until a new row is active. I'm sorry I couldn't reason my way through this. Any thoughts? Cheers, Rodger

How are you trying to use it? =AND(A2+1.5*B2>15,A2+2*B2<30) will return TRUE or FALSE

I know I'm overlooking something, but, I have a sheet the user enters a number and hits enter, no worries, the cursor moves down and highlights the next cell. If you type a number and hit the cursor down button to enter the next one, the cell you are on fills with a formula. how can i make...

Thanks Narayan, not quite the answer, but it pointed my head in the right direction. I am using English Excel. Your answer led me to the correct solution. Thanks again for your time on this one, as with others I have been stumped on. Keep being amazing. Cheers, Rodger

Hi Chihiro; thx for the reply. It still flags that line tho .NumberFormat = "0.00;0.00;0"