logical check

I'm trying to create a RAG status for dozens of metrics. Ideally I would like an IF statement that takes account of signage in B and D in combination with values in C and E to assess the value in G to output in H. However it seems you cannot concatenate the signage and values as it thinks the...

I am beyond frustrated and my perfectionist nature won't let me give this one up and I know there are some geniuses here that can help me find a solution but I can't take another YouTube video or confusing tutorial. I have a data source that contains giving records, most records have 12 entries...

Hi All, I am trying to achieve a simple logic. Tried to search over google and forum before asking but couldn't get anyway near. I am currently using below formula which is working fine but need to manually delete extra rows to obtain conditions. (In Table) =IFERROR(VLOOKUP([@[Mobile...

Hi, I am creating a spreadsheet with several values (one Text value in each cell) i.e. <tbody> Row1 Col. A Col. B Col. C Col. D Col. E (The Result) Row2 Apple Banana NA Pumpkin NA Row3 Cherry Apple Mango Pineapple NA Row4 Apple Banana NA Pumpkin Apple </tbody> I wish...

So I am pulling out my hair here, trying to figure out why over the last two months, this formula has been working, and now it stopped. I have duplicated my previous work to the letter, I have double, triple, and quadruple checked my data sets. I have named and re-named my ranges to ensure they...

Hi, I am using a macro to pull data from a PDF sadly for some reason when I pull the lines of data random "." appear in the data. I have a test to run through each line and format the special characters out but sadly It condenses everything down, so now instead of removing all characters I...

Hi All Im am trying to write VBA code. I have a excel with 2 sheets named Current trades and opening position and third sheet i have added just for example of output. I want to create code based on following codition. Can anyone help me...It would be really kind. I generally can read...

Hello, I have a formula which goes something like this =IF(D7="Yes/No?","Select Yes or No on Instruction sheet", IF((D7="Yes")...

Hello All, I'm having a bit of a problem understanding the logic behind For statements in VBA and I was hoping someone could clear it up for me. I was basically trying to recognize if there were any blank textboxes in a userform, and assign different actions accordingly. Here is my code...

I'm trying to figure out if there is any way of performing a logical check (possibly by way of a custom function?) to ascertain whether a cell contains a text string (no numbers) and is all in upper case (or lower case, or Proper Case). The reason for this is that I receive approx 10,000 rows...