guys

Hi Guys, I am trying to write an if statement based on the results in cell A1 and i cant seem to get this correct the rules i want to apply in the statement are If A1 > 0.49 then A1=100 If A1 > 0.39 and less then 0.50 then A1=75 If A1 >0.29 and less then 0.40 then A1= 50 how can i write this...

hi, I'm a newbie with excel VBA. I'm building a multi page userform and thanks to this forum and several other forums I was able to arrive at this point. But here's the catch: >> Update button only updates columns on the resultbox. I tired modifying the code that populates worksheet on...

Hello guys i have another question for you guys.... is there a VBA that can in active worksheet CLEAR the contest of a row in selected range...lets say i have text sorted in rows....and i want that i can with macro search for value or criteria text letter ž or in (english f for female) in range...

Hey Guys.... I have this chart......(in F1 thru F4 there will be various numbers) I would like Column OOF to be be grouped starting with #1 for each group Then I would like to work within each group with excel functions... Can this be done? thxs Mike <tbody> OOF F1 F2 F3 F4 1 2...

Hi guys, I have this excel file that I don't know how to start or what to use function or necessarily for macro. I have input sheet, like below: When I input No. and quantity then it will sum to another sheet that match to the column that I inputted. So, once I input No. 1-A, then quantity to...

Hi guys, Can you help me please? I have two sheets that I need to compare, Sheet 1 and Sheet 2, those that are exists in Sheet1, or they have the item then it will automatically be deleted.. Thank you guys in advance.

Hi Guys, =SUMIFS(INDEX(Service!$E$4:$AM$45,MATCH(pay_table[@[Employee Number]],Service!$A$4:$A$45,0),0),Service!$E$3:$AM$3,">="&Data!$C$2,Service!$E$3:$AM$3,"<="&Data!$D$2) This is my formula that works great, but i'm trying to add another parameter to the SUMIF. Which only adds values that...

G'day guys. Need to do a tricky one... I'm not sure how this can be done with a VBA sub routine. Once the data shifts to another sheet ("DATA Currently") I need to run a VBA script afterwards to convert it into the "Data needs to be" values. Anyone got ideas? I'm sure there would be a way...

Hey guys I have another problem if you could please help me, thank you. I have this setup: I want to display 1 in column M for the first item that has the condition Yes, column K is a drop down with Yes and No. I don't know how to stop the second formula to run if the first one is...

Hey guys, I'm not sure if Im posting in the right section, but I really hope you guys can help me with this!!! I work at a college & I have an excel file for my contracts that we do to pay the professors for the classes they teach in the summer. The file is a list of the contracts created & I...

Hey guys, I'm not sure if Im posting in the right section, but I really hope you guys can help me with this!!! I work at a college & I have an excel file for my contracts that we do to pay the professors for the classes they teach in the summer. The file is a list of the contracts created & I...

Hey guys! How do I get the following number format in a clean format to calculate the duration? The numbers consist of hr min sec - two items each. hyundai accent 2012 0 to 60 The problem now is that the close of the day is defined as 240000. The second problem is that some minutes and...

<tbody> ID Arrival date Date Text Date Text Date Text 1 01/01/2000 01/01/1991 xx 01/01/1999 yy 01/01/2015 zz 2 0/01/2001 04/06/1998 cc 05/06/1999 vv 12/28/2000 bb </tbody> Hi Guys, First timer here. I need to find the date closest to but before. I have used index...

Hi Guys, I have the row number of some values in a sheet (column E) see picture. I need to delete the row where the corresponding value sits. I have used match to give me this as you can see from the picture. The issue is that the value sometimes can be present in the look up column...

Hi guys, May you guys help me on this as I want write this set of function in to macro. Many thanks Function =if((and(sheet1!A2=Sheet3!$b$1,sheet1!j2=sheet3!$b$2,sheet1!u2=sheet3!$b$6)),(if(or(sheet1!j2="a",sheet1!j2="b",sheet1!j2="c"),sheet1!bn2,sheet1!bo2)),"") Many Thanks

Guys I want to create a code , This code will query a subject for example "facebook" and will count how much emails received with this subject from inbox and will put these emails in specific worksheet that i create with the name "facebook" for example

Hey Guys - i need to get the specific cell value if the answer is "NO" can you help ? pls see the snap shot i have attached and as per that. B3 should have C3 value instead of "NO" https://ibb.co/eHHO79

Hi Guys, Silly one that i cannot figure out, How do I get cell values to repeat down a list of cells based on the value of the cell before? Example: Cell F2 has LINK10 and in cell G2 I enter a value TEST for example, I want that to then fill in TEST all the way down the list everytime...

Hey guys. Anyone know a way to autopaste a worksheet into Word or better again - Notepad, without using a macro?

Example If i were to input a value '240*' in Cell "A1", it will auto filter another column in another sheet column D Is it possible? I would like to use the cell to filter instead of using the filter option? Would be great if you guys can come out with a script. Thank you in advance and and...