1. R

    Copy Specified Columns from Multiple Workbooks to one Workbook

    Hi i have more than 50 workbooks with same data but i need specified columns in one workbook example sharing for your Reference [Crazy Mart]-Workbook1 <tbody> Item Name Price Oranges 50 Apples 35 Banana 25 Pomegranate 60 </tbody> [Trail Mart]-Workbook2 <tbody> Item Name Price...
  2. E

    Formula to find new product and add to list

    I would like a formula to grab new products and add them to a list. For example, I have two tabs. In tab A, I keep track of how much we sell/buy by product (so we bought 10 apples and 15 oranges and sold 10 oranges) and in tab B is a sumif formula to add up the sum so we know how much of each...
  3. H

    If/Then with Multiple Ifs

    Hi - I'm wondering if I can define a letter, "X", to represent multiple values in an If/Then statement. The code is not complete and just an example of what i would like to do: x="Apples", "Oranges", "Pears", "Grapes", "Banana", "Strawberry", "Blueberry" If Sheet1.Range("A1") = x Then Rest...
  4. J

    Round Value Based On Criteria

    Hi, I would like to be able to take a quantity and "round" it based on a list of rounding criteria. I am having trouble trying to find an exact example of what I an trying to do nor am I having any luck myself with the different formulas. I have created an example using fruit if someone could...
  5. B

    Formula merging a countif with a second if statement

    Sorry for the vague description but not sure how best to describe this. Here is the situation below. I want column C to be a formula. Out of all of the occurrences of Oranges in column B, if any of them have a value of 5 or above in column A, then I want it to return a Y in column C for all...
  6. montecarlo2012

    VBA - Wrong results for a for next loop.

    Hello. This code do not give me any error return; but do not give me the right results either. I am trying to get the total of oranges sold only, on "C1". My data Fruit's names A, and quantity sold B and this is the code I tried. Sub Fr_Sd() Dim LastRow As Long...
  7. N

    Move to new cell.

    I have cells that have multiple lines of data that is seperated by a return. Is there any way to break these returns into their own cells? EXAMPLE: CURRENT <tbody> A1 APPLES BANANAS GRAPES A2 ORANGES MANGOS </tbody> <tbody> A1 APPLES A2 BANANAS A3 GRAPES A4...
  8. S

    Address formula

    Hello. I have the following table: Line1: Product | Minutes1 | Minutes2 | KAPPA Line2: Oranges | Africa | | 2 | 1 | 15 Line3: Oranges | Africa | 3 | 1 | 15 Line4: Oranges | Africa | 2 | 1 | 15 Line5: Oranges | S. America | 3 | 1 | 15 Line6: Oranges | S. America | 5 | 1 | 15 Line7: Oranges | S...
  9. K

    Sequence filling of table for order picking based on current inventory

    Hi all, I am trying to find the best way to fill up a dynamic table with the right values as easily as possible (hopefully one click) once I input the the order number and it's details. I am stumped not sure whether I'll need to use helper columns / vba. I wanted to get the answers to the "To...
  10. C

    vlookup base on a maximum/latest condition

    Hi guys, I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: <tbody> Apples ordered 2/4/2019 Oranges backfilled 2/4/2019 Apples arrived 3/4/2019 Oranges arrived 3/4/2019 Apples backstock 4/4/2019 Oranges missing 4/4/2019...
  11. F

    Convert selection to SQL ANY() format

    I frequently need to convert a range of Excel data into an ANY() function format (table below) for PeopleSoft queries. Once I convert the format, I copy/paste into PeopleSoft. First column is an example of original data and the second column is the end result. Maybe I can just use custom...
  12. S

    Identifying duplicate values and then returning a combined value if duplicates exist

    Hi, can anyone help with with this problem. I have a list of data where I've done a conditional format to identify duplicate email addresses. I've tagged each email address relevant to the user's interest. So imagine you had a user who had three interests and another with 2 and another with 1...
  13. S

    Priorities in Excel

    Hi everyone, I have a data set like the following. Unfortunately, my data is a lot more complex than this so a simple Pivot won't let me analyse it :( <tbody> Name/Year Apples? 2016 2017 2018 John Apples Apples Oranges Emma Apples Apples Apples Dave Oranges Apples Oranges </tbody>...
  14. P

    Not sure if this type of search and display is possible...

    For example, I have the following data set: <tbody> Name Fruit1 Fruit2 Fruit3 1 Bob Apples Oranges Pears 2 Jill Oranges Apples Bananas 3 Biff Apples Oranges Pears 4 Tad Bananas Pears Peaches 5 Peg Grapefruit Apples Pears 6 Bill Bananas Pears Oranges 7 Don Oranges Oranges Oranges...
  15. Y

    extract data value from Pivot filter (Multiple Items)

    Hi Guys, i wonder if there is any way to extract the value of the filter on the pivot table when you select more than 1 criteria? For example: If my filter criteria has "apples", "Pears", "oranges" and I select "Apples" and "pears" in the filter criteria, the value of the filter is shown as...
  16. B

    IF and VLOOKUP to find column header for values in range greater than zero

    I am trying to setup an IF statement using a VLOOKUP to find a value in a range greater than zero and return that column's header label. I have a list of names and I am trying to find the first column that has an actual dollar amount instead of blank and then return that column's header label...
  17. A

    Stumped Again

    I can do a join/transpose with one column but nothing I have tried will do a join/transpose with the condition being in two columns. Below is a sample of what I am trying to do. Thanks for any help you may give. <colgroup><col width="65" span="4" style="width: 65pt;"></colgroup><tbody>...
  18. E

    Macro to copy date related date from one sheet and paste into new sheet

    Hi all, I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want...
  19. M

    Exclude numbers for cell that also has Text

    If I have the following all in cell A1 40 2 Apples and oranges How do I just get Apples and Oranges also the text could have varying number of text and the numbers at the beginning can also change to varying degrees. Thank you MM
  20. X

    IF statement to show value depending on two SUMIF results

    Hi guys, I'm trying to do an IF statement to show "Apples" if a certain sumif based on a range is greater than another sumif based on a different range e.g. Oranges. And then it should show "Oranges" if the total value for the cells that correspond to "Apples" is not greater. Here's what I have...

Watch MrExcel Video

This Week's Hot Topics

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