multi columns

Hello! I am trying to find matches between multiple columns of text and having a terrible time getting the formula correct. I had 2 individuals rate items using 2 letter codes. They could give each item between 1 and 4 different two-letter codes (with 9 unique two-letter code options...

If anyone can help that would be excellent. My issue is i have a workbok with 12 sheets and 7 of the sheets are results of existing macros. I want to print the results of the 7 returned sheets but only up to column O on each sheet. Each worksheet runs from A-AD but i only want to print A-O...

Hey so I just wanted to see what the opinions are on how I should tackle the probelm I am trying to solve. Below is what my table looks like and I need to paste in a number to its corripsonding cell. The program should find out what the crop is (found on another worksheet) and then find out...

Hi Guys, I need your help to find a clue how to build this formula to list Case numbers from returned surveys based on customer mobile number. Please see short example down below. I was trying few combinations of VLOOKUP, INDEX, MATCH, but without success. Any clue? Thanks. Rich. <tbody> We...

Good morning to all, I am trying to populate a multi column listbox but keep running into an error that must be caused by my code. I don't understand how the properties are for a multi column listbox and I am looking for a resource to learn how. So far I know how to use a single column list...

I am working on a user form that populates a combo box with data for a user to select. To make it user friendly I wanted to populate one column with data a user can understand such as a date. The date a user selects should correspond to a worksheet name which I would like to put in the other...

Hi all, this is my first post so I apologise for my lack of forum lingo and knowledge! I have a situation where I have a rather large spreasheet, that we populate each week with 35 columns and 20,000 rows worth of data. At the moment we have to manually go through this data and look at certain...

Hi, I am trying to code 7 multi column in listbox, but trapped. code : Do Until NumCounta = 1 NumCounta = NumCounta - 1 a = Range("a" & x).Value b = Range("d" & x).Value c = Range("e" & x).Value d = Range("f" & x).Value e = Range("h" & x).Value f = Range("i" & x).Value g = Range("j" &...

I am trying to do a vlookup based on 4 values. I have 4 drop down data validations in a row. The first one has the type of material, the second has the height, the third has the width, and the forth a depth. My data is set up in this manner because it's a lot of data and trying to select with...

Our office recently was upgraded to MS Office 2007, and I am having a pickle of a time trying to create a multi columned stacked bar chart.... its been a while but i am pretty sure this was easily done in the last version.... with the chart wizard gone from this version.. i am lost. Any help...

i have this three columns: <table style="border-collapse: collapse; width: 162pt;" border="0" cellpadding="0" cellspacing="0" width="216"><col style="width: 54pt;" span="3" width="72"> <tbody><tr style="height: 11.25pt;" height="15"> <td class="xl64" style="height: 11.25pt; width: 54pt;"...