pears

  1. earwig999

    Chart to compare two data sets

    I'm trying to produce an excel chart to show responses to a survey from two different sources. e.g. What trends do you think are permanent or temporary? Apples - P,T,NS Pears - P,T,NS Now there are results from a National survey and then results from Local survey. The options people select...
  2. D

    I have no clue

    Any help would be greatly appreciated. I have a list of inventory (col A:C) with 3 criteria. I'm trying to figure out how to add conditional formatting to the table on the right (col E:I) that highlights the cells (g2:i10) if they are present in the list on the left. I've marked the cells...
  3. G

    Find matching opposites

    Hi all, First of all, great forum so cheers for the help already provided just by scanning the posts! I've got one that couldn't find so hoping someone can help me out. I need to find matching opposite pairs by value in column B (by opposites I mean negative and positive values) which relate...
  4. E

    Index Match with multiple nested if statements

    Hi, I have two tables, one with "source" data as follows: <tbody> A B C D E F G H I J K Lookup Helper High Low Geo_Lookup Geo_High Geo_Low Other Class Description Important A1 A1 11 Apples & Oranges N A2 #ALT 2 Apples & Pears N A2 55 High Apples & Pears Y A2...

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