Really, if you expect help, then you need to provide a realistic workbook. How do you expect anyone to determine a category for your accounts when all have the same description ("xxx"). You need to provide a realistic example. Account numbers or description. You also need to provide a look up table. Excel cannot think for you. It needs to make rationale decisions based upon information provided. At this point, you will need to research Vlookup as the function you need. Good Luck.
Posts by alansidman
-
-
Click on Attachments at the bottom of a new post in a thread. Between Smilies and Settings and above Reply.
-
Not talking about code. Need to see your source data in a spreadsheet and not a picture. Attach a sample file. We cannot manipulate data in a picture.
-
Pictures cannot be manipulated therefore, please upload your sample data so that we can provide you with a solution specific to your needs.
-
@emadghzi
the post you have responded to is from 14 years ago. I doubt that the OP is still looking for a solution. Please try to keep your posts to more current situations.
-
Please read the forum rules you agreed to when you joined and abide by them in the future. In this case, I have added code tags for your post because you are new to this site.
Alan
-
My apologies I did not see the link. Will look now and see if there is anything I can offer.
-
Cannot manipulate data in a picture. Please upload a sample worksheet and a mocked up solution so we know exactly what your expectations are.
-
Attach a sample worksheet (not a picture) so that we have a facsimile of what you are working on and can offer a workable solution.
-
Pictures cannot be manipulated. Attach a file with your Mcode that is not working.
Second Look. Maybe your spacing on the header for discount % is not exactly as it seems. Make sure that there are no leading or trailing spaces. But to be sure, read my first sentence above.
-
I have amended your post by adding code tags. Please read the forum rules you agreed to abide by when you joined.
-
With Power Query and a Group By function, here is the Mcode
Codelet Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Grouped Rows" = Table.Group(Source, {"discount %"}, {{"Data", each _, type table [product name=number, #"discount %"=number, attracting level=text]}}), #"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"product name", "attracting level"}, {"product name", "attracting level"}), #"Sorted Rows" = Table.Sort(#"Expanded Data",{{"discount %", Order.Ascending}}) in #"Sorted Rows"
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality.
- Follow this link for a video which demonstrates how to use Power Query code provided. -
Please provide a sample workbook (10-15 records) showing your current data and then a mocked up solution of what you expect. Do not post a picture as we cannot manipulate data in a picture. Attach an excel file.
-
Please post a sample workbook so that we can manipulate data specifically to your case. Do not post a picture as we cannot manipulate data in a picture.
-
I'm sorry, but I have no idea what is happening here and do not have a valid solution.
-
Provide a sample workbook so we don't have to create one and can create a workable Mcode for you.
-
How about loading the pdf file here or a facsimile of it with dummy data. Can't help with current data.
-
In Power Query, you can bring a PDF file directly into the PQ editor. On the data tab, Get and Transform, Get Data, From PDF. No need for the extra steps.
-
Power Query Solution Attached.
Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").
It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.
- Follow this link to learn how to install Power Query in Excel 2010 / 2013.
- Follow this link for an introduction to Power Query functionality. -
You will need to wait patiently for a VBA expert. You may want to look at the following, however while you wait.
Consolidate Multiple Excel Sheets Using Power Query Append | MyExcelOnline