hits

I need to edit the code below so it stops counting when it hits 0. SUggestions? =COUNTIF(K5:K29,"<=30")

I've designed a simple userform with 3 radio dial buttons, an OK and a Cancel button. How do I write the code so that when a user chooses OptionButton 1, then hits OK, the operation I want to perform is performed. I feel like I should be getting this more easily! Appreciate help and guidance.

I like to play a simulation baseball game where each batter has a card which attempts to replicate the players actual performance and dice are rolled to determine the player bat outcome. The company that sells the game also sells a spreadsheet and claims the player data from the cards is in...

OK, I have expiration dates in cells B3:B100 when TODAY hits that expiration day that cell turns red, in cells C3:C100 there is a Expiration day -30, when TODAY hits -30 days from expiration day that cell turns pink. I want to receive an "alert notice" via email when C3:C100 turns pink. i.e. i...

I was able to obtain TRUE or FALSE from multiple keywords using: =OR(ISNUMBER(SEARCH(H$5:H$12,D5))) but how can I return the # of hits? Thanks for your assistance!

Hi, I am trying to get a result from two variables. Variable 1 is a name, say Ian. Variable two is a number (number of sales). If Ian hits a number of sales, then a certain commission value will be returned. If Ian hits 999 sales, he gets a different commission to 1000 - there are various...

Hey guys i have taken some code from online to create a countdown timer and when it hits 00:00:00 a msg box pops up but i want the box to pop up when the timer hits 00:05:00 (5 min remaining ) can anyone help? thanks Public gCount As Date Sub Timer() gCount = Now + TimeValue("00:00:01")...

001= 0 hits in 8 draws 002= 1 hit in 8 draws 003= 2 or more hits in 8 draws The HTML maker would not work. Hope this works. The values in columns A<B<C<D<E are in column F ranging from 1to 42 Using the criteria above I need count formulas for columns G<H<I<J<K to return those values. All...

Hi, MrExcel virgin here.... I have two formulas that find the data for a 1st hit, (either =VLOOKUP(A107,'Yr6 Wk1'!C5:D250,COLUMN(D:D)-COLUMN('Yr6 Wk1'!C5:D250)+1,0) OR =IF(ISNA(MATCH(A107,'Yr6 Wk1'!$C$5:$C$251,0)),"",VLOOKUP(A107,'Yr6 Wk1'!$C$5:$D$251,2,FALSE)). These both work fine, what I...

Hi I am a newbie at excel and just joined an advertising firm. I have been a given a project to complete in excel and it's a bit difficult for me given my experience with excel and based on whatever I know I am pretty sure the task I am trying to automate using excel formulas is not easy. I have...

G'day guys... New project came up and I'm clueless where to start on this one. The idea is simple enough, emails will hit Sales@inbox.com.au which will go into a pool of sales inquiries. When someone hits a button, they will get the oldest/or newest email extracted to a dashboard or excel as...

Hopefully I can explain this correctly. A2:A15 - Players last name B1:B15 - Dates of games The number of hits are entered for each player, on the date played. (actually are populated from a different page/tab in workbook) I am HOPING to change color of the TWO or more cells when the...

Hi Guys! I am new to this forum and no great shakes at Excel, but I have a problem that I hope that you can help me with. My actual data is more sophisticated, but I have simplified it here for the purposes of clarity. I have a simple two column spread sheet. Column 1 shows the Names, Columns 2...