if condition

Hi, I have this table ... this is a part of millions of records. I have functions that show if STAT is 1 or 0, if type is E, if type is CA. This example shows that the same work 24188686 has one E and two CA. If I filter columns I can see either E or CA from the same work. I would like to...

Hi everyone! I'm a total VBA newb and I require some professional assistance getting my code to work. I've searched far and wide with no luck and I'm getting quite desperate. All kind of help will be greatly appreciated! In short, I need my code to search through Excel workbooks in a...

Hi everybody at MrExcel, We are from a university. We have SIX specializations, Specializations------Codes Finance ----- F, Marketing ----M, HR ----H, Finance with Marketing ----FM Finance with HR----FH HR with Marketing------HM We have six subjects in each combination i.e...

Hi! Here is the values and conditions: <tbody> A B C 1 Customer Target Achieved Commission 2 Bernard 54882 3 Norbert 13420 4 Maggie 91472 5 Smilly 33542 </tbody> Coniditions: Target < 15000 commission is '0' Target > 15000 < 30000 is 2% calculate commission value...

How can I create a calculated field in a pivot table that will count distinct values of Field1, given that Field2 meets a particular condition? My limitations: Needs to be in a pivot table Needs to be a calculated field The calculated field needs to be a unique count "formula", not simply a...

I got a list of clients that have food restriction like this: <tbody> Client Restriction1 Restriction2 Restriction3 Restriction4 Restriction5 Zed Rice Pasta Fish Fried Food Apples Charles Rice Fish Fried Food Carl </tbody> And a list of foods that I serve in my company like...

Hello Friends I am trying to understand how I can use Hex in my if statement rather how below mtioned code is working in if condition. Sub test1() Const T = &H1 Const P = &H2 Const D = &H20 R = P + D If R And P Then Debug.Print P End If If R And T Then Debug.Print T End If End Sub...

Hi, I have a list of names (Column A) and their marks in a adjacent column (Column B). A same name is also listed more than once and hence i am looking for an excel formula that can pull top 10 lowest marks and top 10 highest marks for a same name. I need the output in Column F and Column G...

Hi everyone! I'd be greateful if anyone can help me on this complicated query. Maybe easy peasy for you :confused: I'm a structural design engineer and I want to develop my own spreadsheet to calculate required area (mm^2) of reinforcement bars in concrete to avoid concrete cracking due to...

Hi all, This is my first post in the forum and hope to learn excel from professionals who are in this forum. Just I start to learn MS Excel and have a confuse in IF function. This is my question, I am trying to write a function and can't seem to figure it out. Could anybody here help me...

Help me Pass percentage 40 In D2 cell i use =IF(B2>=80, "Excellent!", IF(B2>=70,"Congratulation!!", IF(B2>=60,"Satisfactory!!", IF(B2>=40, "Try to get better position. "," Stress on the all weak subjects.")))) Above formula work for Hari, Ram, Shyam, Gita because they are passed and...

Hi, I have an excel file with the below format. Now i want to put rank for the event. Here I am manually put the rank (rank 1 Only) on the last field. Please can you give the formula instead of manual? THanks <tbody> Event Time Details lay RANK Catt 20th Oct 13:40 5f Nov Stks 3.3 1...

Can any one help me with this: I have an excel file which needs to be updated daily from another file as per below; currently it is manual but surely there must be a macro to automate it. (Never written a macro, so this would be the first one) Format File 1: Lets say: Product no Month Actual...

Hi all, I am trying to use ADODB connection stuff to read and copy data from a closed book. The code will look for an excel file, read and copy the data into the sheet "PnL_T-1". Generally the macro will read the file dated as of yesterday (Date1), but sometimes I will need the macro to read...

Hi Guys! I need a script which checks the alphabetical order of a ray. For Ex. If (A2:A4) in alphabetical order Then . . If not . . End If Thanks A lot!

Hi Guys, I have some Text ## values in a A1 and B1. And some text values in A2, A3, A4. Example: A 1. T ## 2. D 3. H 4. F What I need a script which sorts the text values in their alphabetical order variations according to conditions given below...

Hi to all Brainee Folks, I have a piece of VBA code which compares Column:A(Sheet1) with Column:B(Sheet2) and prints the unmatched values in Column:B(sheet2). I used resize to fetch the entire row of Sheet1( unmatched values) and writes in Sheet2. Now my Immediate requirement is, i need to...

Can anyone tell me how I can put an IF conditional statement into an Excel 2007 pivot table. =if(or('Project Status' = "Funnel", 'Project Status' = "Pipeline"), 'Estimated Start Date', 'Actual Start Date') I have two data fields Actual Start Date and Estimated Start Date and want to create a...

Without going into too much detail of the process, the tool I am designing allows the supervisors of a net repair shop calculate how long each panel will take to complete, and what time the net will be completed at. To calculate the time, the supervisor enters in information on each panel, and...

Hey all, I have two names like this: PRIMEAU,I & PRIMEAU,JANETTE BAIN ED & HELEN which are similar but different than the following: AVERNA,ROBERT C Corn,Marlin Lizand,ROBERT H CATANESE,SALVATORE J & OLGA M JIMENEZ,ALEJANDRO & HILDA M Hernara,Harry & Marie Anne Martin White,Alex & John M...