urgent help needed

  1. W

    Macro to filter from values in column based on active cell

    I need some urgent help. I need a macro which would filter items within a column based on the entry that is on the active cell (as in the cell which is active). I came up with the following using the Record - but right now it is looking up the specific name "Adam Hill" - - I would like it to...
    • wsarij
    • Thread
    • active cell filter macro urgent help needed vba
    • Replies: 6
    • Forum: Excel Questions
  2. A

    Producing charts from data

    Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data... <colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody> reviews Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13...
    • AlexQ
    • Thread
    • data analysis graphs scatter graph urgent help needed
    • Replies: 1
    • Forum: Excel Questions
  3. R

    Formula too long error in excel for OSX

    Hi, I need a way to get around this error because I need this formula to work in the next few days. The formula is as follows: =CONCATENATE(LEFT(B11,FIND(",",B11,1)-1),"...
  4. B

    If cell equals text then cell returns text from another cell

    Hi, i am am trying to return the value of a cell if another cell equals text for example in cell a1, if cell b1 = 'yes' then return the data in cell c1 into cell a1 if that makes sense? thanks in advance
  5. I

    vba for alphanumerically sorting column

    <tbody> <colgroup><col span="2"><col><col><col><col><col><col><col span="2"><col><col></colgroup><tbody> 1 How Have You Been? Receptive communication Dialogue (2) Unit 1, Lesson 5 Michelle Lapides, Kenneth Ness, Andrew Weidig x 168 Role-Shifting Three Characters: Me explain do-do...
  6. S

    How to stop a formula when the IF statement is true

    Hello, I am working on a formula that has many nested IF statements. I am calculating distances from stores, where the distances are in a matrix. Here is a short version of the formula to get from store to store...
    • sb1989
    • Thread
    • if statement help if statements index & match matrix formula urgent help needed
    • Replies: 1
    • Forum: Excel Questions
  7. G

    URGENT! Please help

    I have two spreadsheets that have stock information for two departments, "Goods in" and "QC". I am trying to update the "QC" sheet automatically from the "Goods in" sheet. When a date is inserted into the "Goods in" sheet (column w) the "part no (j)", "quantity (k)" and "date released (w)"...
  8. J

    PLEASE HELP - URGENT - Customer database analysis problem!

    Hi, New here, reasonably new to excel so apologies if I am a little unclear in my explanation of what I'm needing. I have exported a database file that lists each individual transaction that I have processed in my shop over the past 12 months (over 10,000 rows), each transaction row lists...

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