iii

Hi, I'm looking for a True or False response for the following scenario: If the description in column C contains the model number from column B then the match is True. My problem is that as you can tell the Description has the full name of the model but column B has an abbreviated version "IR...

Hello All, I have this issue have been trying to solve for a while now and cant seem to find any solution. I'm hoping someone here can help me. Here is the issues. I have data that comes to me in this format and it have a few more columns and rows. Dept Users Finance I...

Data as below <tbody> Parent Child AAA BBB BBB CCC AAA DDD DDD EEE EEE FFF CCC GGG GGG HHH HHH III III JJJ III KKK JJJ LLL KKK MMM MMM NNN </tbody> and continues. Output should be collapsed. EX. as below <tbody> AAA + BBB + CCC + GGG...

Given an Integer value , convert it into Roman number. roman numbers are like I : 1 V : 5 X : 10 L : 50 C : 100 D : 500 M : 1000 IV : 4 IX: 9 XL : 40 XC: 100 CD: 400 CM : 900 example Input : 3 Output :III Input : 58 Output :LVII

Hi all, I am always confused as to what Excel is doing when putting array arguments into an IF function. for example, if i have the following 2 arrays: Array A: 1, 2 3, 4 5, 6 Array B: I, II, III ref cell <--to input a number for comparison and if I have the following formula: =IF ( ref cell...

Firstly, apologies for how the data appears on here I am trying to calculate the total sum of X.Y or Z for all section A and B For example A - X should = 29, Y = 15, Z = 24 The formula I have used only returns the sum for column I and not all columns I, II, III, IV, V...

Hello All, A workbook I developed is crashing on a vanilla copy/paste. At bit of background: * No VBA * Issue happens whether I use toolbar or shortcut keys * I have tried: (i) copying to another workbook; (ii) removing conditional formatting; (iii) unhiding and ungrouping rows and columns...