iii

  1. W

    How to find a Partial Match within another Text Cell?

    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...
  2. O

    Formatting data to use in pivot table

    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...
  3. K

    Parent - Child Hierarchy

    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...
  4. Y

    Converting numbers to Roman numbers

    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
  5. C

    Taking Array Arguments in IF function, what actually are going on?

    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...
  6. B

    SUM/Array Query using multiple criteria

    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...
  7. D

    Excel crashing on Copy / Paste

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top