advance

Hi all, Is there a VBA macro that looks to see if a cell has a value? For example: "If Cell(123) has a value then xyz end if" Thanks in advance for the help.

Hi, Is there a better way to achieve this formula...

Hi. In the linked spreadsheet, please could someone fix the count in column 'T'. It keeps counting one too many. Thanks in advance. https://1drv.ms/x/s!AtIvkRgReIvwgRbfii9zm52ozImr

Hi, Is there any other alternative or shorter solution for rewriting the below formula example.i have read in an older post that the SUBSTITUTE function cannot handle the "old_text" part as an array{1,2,3,4,5,6,7,8,9,0} Thanks In Advance. <tbody> A1B2C3D4E5F6G7H8J9K0...

Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing...

Hi, I'm quite new to excel and I need to find the probability of 3 different criteria. My criteria is finding the 'females' who live in 'london' and earn a net wage of 'greater than or equal to £495' can ANYONE help me with the command or formula I need to input to get the answer as I am loosing...

I may as well be reading Chinese as my math doesn’t yet extend this far. Please excuse me I am just an aspirant practitioner. Can an excel formula be made to solve given values/variables for this equation? Thanks in advance. :confused:;) https://ibb.co/b3GTr7W

Hi. Can anyone please quickly provide an alternative formula to create a dynamic named range which will use the index function as opposed to offset or indirect. Sorry, can't get my head round this one. I have : =OFFSET(Demographics!$C$2,0,0,COUNTA(Demographics!$H:$H)-1,29) This captures all...

I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html and this is the continue of my macro which I believe has to change what I had help with yesterday . Sorry for not thinking the whole thing through before posting Here is what I...

Good morning, I am pretty new to VBA. Just wondering is there a shorter way to write multiple or's in VBA. Thanks in advance If (gradelevel = 1 Or gradelevel = 2 Or gradelevel = 3 Or gradelevel = 4 Or gradelevel = 5 Or gradelevel = 6) Then

Hi, I'm looking for how to create a win or lose (no ties) combination in an excel for 16 teams and 8 games. I know there are 256 combinations, but how can I have this combinations listed in excel? Thanks in advance Damien

hi, I would like to discuss on how to get sorting ascending formula from this case. Expected result is as shown in the picture in blue column. The only reference that can be used is Rank column (Yellow) and Group column (white). Any idea how to get the rank unique expected column (blue)? do you...

Hello, I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance. =IF(B38<1,0...

Trying to return a blank instead of a #N/A or 0 with INDEX and MATCH. Formula Below... =INDEX(Data[GC],MATCH([Product Key],Data[Product Code],0)) Thanks in advance for your assistance and time. Regards Richard T.

I have an excel Sheet with Column A containing the ANSZIC Code - Ranging from 0 to 9999 There are millions of records and i wanna a assign a code to classify these Numbers as Follows Ex For Numbers FROM 0-529 it must be assigned A, and like wise <colgroup><col><col></colgroup><tbody> 0 – 529...

Hi,</SPAN></SPAN> I need a formula that can find second last value in the column either it is number or alphabets.</SPAN></SPAN> Resulting data...cell </SPAN></SPAN>C1 Book1ABCDE1X2P13P14P1516X7X8X9210111X12X131141516Sheet11 Thank you in advance</SPAN></SPAN> Regards,</SPAN> Kishan</SPAN>

OK Guys so I have been using this formula and it works perfectly, the issue im running into is that the column is a date which can be put in in several ways and I need to see it exactly as it is entered, so I am changing the column to "Text Format" but that means my formula will no longer work...

Hello, I have been looking for a formula and still get errors! If F2 <=110 = Short term OR IF F2 >111 OR F2<220 = Medium term OR IF F2>221= Long term I am looking for one formula with the 3 possibles results. Thank you in advance for your help! Zab

Hi I wanted a formula and conditioning formatting for 3 conditions, If training is past expiry date to go red and say expired, If not due stay green and say not due. if 30 days or less to go say - 30 day or less and turn orange. Thanks in advance and any help will be appreciated.

I've been trying to pull apart a string into it's parts. I've sorted out some of it, but the last little bit is driving me crazy. Example CTH KGB01 3.171 (07) (SH) (Scooby Doo) I need to pull out the Scooby Doo part, and do it for thousands of different lines. The (SH) is not always there, so...