art

  1. D

    Concatenate function

    I am trying to add text using the concatenate function....for example=concatenate(a2,b2,c2) which works fine however if I try this =concatenate(a2:c2) comes back with a hashVALUE error....but...... What I am trying to achieve is to extract data from a report which gives me the subject the...
  2. F

    Conditional Format query

    Is it possible to highlight cells based on another cell. That is a bit of an oversimplification. My table looks something like this: <tbody> Choice 1 Choice 2 Choice 3 Choice 4 Choice 5 Choice 6 Option W Option X Option Y Option Z History Spanish Media RS PE Art History Spanish Art RS...
  3. F

    2nd most common entry if

    Hi Any ideas how I can get the second most commonly occurring text value based on an if. The data I have is as follows: <tbody> A B C Class Teacher Subject 10x/Ar1 AOW Art 11x/Ar1 AOW Art 11z/Ar1 AOW Art 7L10/Ar AOW Art 7L3/Ar EBE Art 7L8/Ar EBE Art 10y/Ci1 RAM Citizenship...
  4. F

    If value in column x and y is greater than 2 list all names

    I know I have asked this question previously and I really can't figure out a way to do this so thought I would try this amazing forum again :) I need to populate the table below: <tbody> Last Name First Name Reg Group Art Group Art Teacher Art Target Art EFG Art EFG-FFT Art Effort Art...
  5. F

    Extract unique list from column a if column x has a value

    As the title says really. I have a table which looks something like: <tbody> Ethnicity English Maths Science Triple Science Art Drama Citizenship Geography 1 Black Caribbean Y Y Y Y Y 2 Afghan Y Y Y Y Y 3 Afghan Y Y Y Y Y 4 Indian Y Y Y Y Y Y Y </tbody> So I want a unique...
  6. N

    Sum in column B depending on values in column A?

    Hi, I am looking for a solution for the following. In the column on the left I have different article numbers, each article number has one or more (up to 20) Sales Orders attached to it. For each article number, I would like to see the sum of all Sales Orders attached to that specific article...
  7. R

    Question on Smart Art VBA

    Using VBA, is it possible to change the RGB color (say green) of a selected element within a smart art object (say Org chart). I know that we can do it if we know the element number - how about an element selected at random? Please advise as soon as possible.
  8. L

    Replacing Data Validation references

    I know how to clear data validation in a range of cells or change the list reference But I have over 600 cells that need changing so even copying is a bit arduous What I would like to do is replace my list =listname with a different =differentlistname so I don't have to go into 20...
  9. J

    Capturing Catalog Data

    Hello all! I am wanting to take information and put it in a separate worksheet if all the information is the same in column C, F, and G If so, I would like to pull the Low Year (Column A) and High Year (Column B) So basically want to say from 2002 - 2005/ ART 101/ INTRODUCTION TO ART/3 CREDITS...
  10. A

    Last Row checking all columns

    Sub ArtReport() With Sheets("art report") .Unprotect lRow = Worksheets("art report").Cells(Worksheets("Invoice").Rows.Count, 1).End(xlUp).Row lRow = lRow + 1 'Inv no Sheets("Invoice").Range("I8").Copy Worksheets("art report").Range("A" & lRow).PasteSpecial xlPasteValuesAndNumberFormats 'date...
  11. T

    Grouping Challenge!

    Hello All, I'm new here, so please forgive my naivety. I've watched dozens of videos in an effort to resolve my issue, with no luck. So, I'm reaching out to the experts. Issue: I work for a printing company. We want to group art across the paper based on label quantities in the most efficient...
  12. S

    Find Differences Between Worksheets and Export to Third Worksheet

    Hello forums, I have a dream of an Excel macro or tool that would make my job infinitely easier, but attempting to cobble it together on my own from Google and forum posts has not proved fruitful. One of my job duties is to take reports that are exported nightly and compare them to determine...

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