I'm trying to clean a dataset and only retain families with at least parent at home. I started going through it manually but it took 7-8 hours to do 3,000 entries and I have 30,000 entries left to do! There must be an easier way so I figured I'd add the criteria here and maybe someone...
I HAVE 4 OUTCOME COMBINATIONS. I couldn't figure it out. it only changed if all three B:E exceeded 84, but I need to change if any of the cell exceeds 84, along with A1
IF A1 IS LESS THAN 1, AND any if these cells exceed B2>84 OR C2>84 OR D2>84 OR E2>84 ="A"
IF A1 IS LESS THAN 1, AND any if...
I've got a perfectly working Macro assigned to a button to copy paste the contents from one sheet (Designed like a form) to another sheet (Master database - Locked and Protected). This workbook will be shared with many people to fetch data from each.
Now, I want my user not to leave...
I'm trying to create a formula to deliver three different outputs based on conditions of three columns.
IF a2 = 11 AND d2 = 028 return NI Landline OR
IF a2 = 11 AND c2 = 07 return Mobile OR
IF a2 <>11 return Other Number
It;s necessary to check Col C...
I am trying to see if there is a way to achieve my idea without nesting IF AND/IF OR statements in the formula bar. I am not too familiar with VBA, but I imagine there is some code that could help me with the following goal:
I am creating an excel workbook database that will allow users...
I trying to display depending on values from Main cell (cell C) nested with Multiples cell, so far a i have good result but i still need to add a criteria on more cells with some values.
i made a short formula that is working ...