logic

Hi, I have 2 columns Column 1 (CT_Flag) Values: RM, V, EE Column 2 (VB_Flag) 1,0 I need to create a new column with the following logic: If VB_FLAG = 1 then CT_FLAG = V else CT_FLAG Any idea how to get this to work please? Thanks

Hi The code below is to clear the whole sheet except the first row. Rows("2:"& Rows.Count).ClearContents I am unable to understand it. I would appreciate it if you can break it down so I can understand the logic behind it. Thank you so much

Hello Everyone, Seeking for assistance to help solve scenario below... I am looking for a formula which would return a non-blank value in a row and cover some additional logic: 1) if the row has one value (i.e. ROW 2 / B2) return that value 2) if the row has two or more values (i.e. ROW3 /...

Hi, Id like to ask for your kind assistance on this, im trying to create an attendance tracker which would determine the employees schedule and the hours he covers, now will it be possible to automatically fill the the hours by using a formula just by putting the employee schedule under the...

Hi Friends, I need the output as shown in column D(Expected Diff) with basic If calculation. Logic should be simple not much complicated as I will use the logic in some other tool for performance consideration. (Left, Right and Mid should be avoided if possible). Any thoughts ...

Hi hope everyone is well. I have a if formula which i am assuming gets the start date from the given data , but i do not quite understand the logic and how it is doing the, the formula is below ="01"&"/"&IF(MONTH(A2)<10,"0"&MONTH(A2),MONTH(A2))&"/"&YEAR(A2) A2=29/11/2015 the formula...

I have a data with various combinations (Sample illustration below) where values in col1 and col2 reverses and therefore reports. I am looking for a way flag the reversed duplicates (A-->B and B-->A are same to I just want to keep one record) and ultimately delete the duplicates (#3 and #4 )...

<colgroup><col span="3"><col><col span="3"></colgroup><tbody> 5 1 2 10610 2 4 2 3 4 4 10609 2 2 5 5 5 2 10608 2 2 2 3 4 5 10607 1 1 1 3 4 5 10606 4 2 4 5 5 2 10605 4 5 3 4 4 3 10604 2 3 5 1 2 1 10603 4 5 4 4 1 2 10602 5 5 3 3 4 5 10601 5 4 2 5 3 4 10600 5 3 4 1 5 5 10599 4...

I have two 'with' statements that select first visible cell and it's not selecting visible cells in column in order to copy+pastevalue. I just want it to: select first visible cell in column AR=>select down to last visible cell in AR=>copy=>pastevalues I used this exact structure for RC[-1]...

Hi there. I'm making a little model to build up a cost based on a number of list ranges with look ups to a pricing database. I want to be able to look up whether a selection is valid based on a logic matrix that I have made. To do this, I have created a table in the following style...

Do Until lx = 12 Loop 12 is Col L. how do i mention lx is the column to increment..??

Hello, I need some assistance in balancing a decision tree. Instead of showing what to do with a set of inputs, I want to be able to balance the output to zero if the inputs are out of balance. It's probably best with an example... A1 B1 C1 -2 A1 B2 C2 -2 A2 B2 C2 -1 A2 B3 C2 -1 A2...

Doesn't make much since to me If there is data in the N9 cell, it goes ahead and continues the Vlookup, but it it is blank which I assume "" should always be, I get the #VALUE in the cell. My logic says after the first logic is true, it should just return as "" and leave the cell blank, but...

I need logic understanding on this.. I have this value in my column.. also While using this formula, I'm getting answer like this.. =IF(A2="MR",HOUR(A2),"") also Why I'm getting 11 on a1 and a2...where I getting correct on a3 and a4..

Hi MrExcel members, Thank you for reviewing this in advance. Wanted to ask if anyone can help me out with a logic... Okay so background: I have 5 regions I would like to ship to. Let's rank them in terms of best price 1-5 for simplicity. I want to create a formula that says... If I have 150...

Hi I want to know based on what logic vlookup() function will return a value if the last argument was TRUE not False. I tried to use True but could not figure the logic of vlookup() returned value.

Can the logic below be made into a formula? Formula in cell U2 If S2 is blank and T2 is blank then U2 is blank If S2 is populated and T2 is blank the map S2 to U2 If S2 is populated and T2 is populated, then map S2 to U2 If S2 is blank and T2 is populated, then map T2 to U2

Good morning, I am trying to apply a conditional format to highlight where a number sequence in column Q appears more than 4 times OR 5 times in that column. I have tried this formula but my logic is out and I need your guidance. below is the formula logic i am working on: =countif(Q:Q, Q3)...

Hello, in want to use a formula that gives me, in percentage, the value of another cell. For exemple if cell a1 is "2", then it will return the value within the logic 0 is 100% and 5 is 80% could someone help please? thanks

Hi, I need a formulae to calculate Due Date including Week-end and Excluding Holidays only Input = Start Date and No. of Days Output = Due Date Logic = Start Date+No.of Days-Holidays (include Saturday and Sunday)