# aaa

1. ### Move data in column into row

Hello, I have a large excel-datafile with data stored in columns, but want to get all into one row (this format is needed for further analysis).The dataset is too large to do this manually. Below an example: Original Author - Obs.- Obs.- Obs. X aaa bbb ccc Y ddd...
2. ### Function to return range of unique values

I have a Column(H) that is 2000+ rows large, and will increase as I add more data. In this Columns there is only 4 unique values. Ex: H2:H600 = AAA, H601:H1200 = BBB, H1201:H1800 = CCC, and so on.... How do I get the range returned to a variable of all of the AAA, and BBB, and CCC. dim...
3. ### inventory values to update

Hi I am trying to update values in an inventory sheet but if value has no change then i cannot create a formula to show the previous value. Any help would be appreciated. Hope this makes sense. thanks MC cust1 has starting value of 100 cust2 has starting value of 200 Thanks <tbody> date...
4. ### Consolidating rows

I am trying to sum rows based on some criteria. (The Group column is only here to explain that the rows come in "3s"). This is the data: <colgroup><col span="5"></colgroup><tbody> Group Field1 Field2 Field3 Field4 1 a aa aaa 1 1 a w aaa 2 1 a aa aaa 3 2 d dd ddd 5 2...
5. ### Summing lists of consecutive numbers

Hello, I'm trying to figure out a way to better process the data that another program that I use spits out. It gives me a list of numbers with breaks in them and I need to be able to add up all of the numbers just in the contiguous blocks of numbers like this: <tbody> AAA 1 1 2 BBB...
6. ### Using Multiple Criteria in Index Match Array formula

Hi, I was using an Index Match Array formula to get multiple results according to one criteria. In this formula, I am able to get the list of names for location "XX". That is A, D, E...
7. ### VBA for top 5 entries by sum of groups

Hi all I am trying to analyse the following dataset and get the total amount of first 5 items of each group(2 grps in total). I tried to use sumifs but since there are too many unique items in my data, selecting and filtering makes the table too complicated. Thanks for the help in advance...
8. ### How to delete blank cells from a table?

Hello, I'm trying to find a way to delete all blank cells from a table in excel. Each cell is either blank or contains a 3 letter code (example below). <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> aaa ada bdd bdg ger 3r2 aaa...
9. ### Print rows as cols without repeats

Print rows as cols without repeats <ins id="aswift_2_expand" data-ad-slot="9830241510" style="text-decoration-line: none; display: inline-table; border: none; height: 250px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 300px; background-color: transparent;"><ins...
10. ### Query - Filter out multiple bar codes to show only 1 bar code per product.

Hi! My query is this - I have 3 columns. Barcode | Product Type | Product Name | Colour 1234567890123 | AAA | Example1 | White 1234567890124 | AAA | Example1 | Black 1234567890125 | AAA | Example1 | Red 1234567890126 | AAA | Example2 | Purple 1234567890127 | AAA | Example2 | Orange...
11. ### Distinct Count Based on Multiple Criteria

Hello, I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and...
12. ### Use macro to click a shape to enlarge it

Hi guys, I found a excel template which is pretty cool, one of its highlights is when you click a title tag it will enlarge and turn into orange, the title tags are built into excel shapes, I know there is macro behind them but I could't understand the logic of the codes. Can anyone please help...
13. ### Super Advanced Search Algorithm Annoyance

Sooo.. I have a ton of data and I need it arranged all by one Row... And using Regex, and custom order, and ascending.. I'm 90% of the way there, unfortunately I'm now kinda stuck, I need to sort like this : <tbody> AAA AAA x2 AAA x5 AAA x10 </tbody> And Excel does this: <tbody> AAA AAA...
14. ### Help with data that requires weekly hours worked.

Hi, I have an excel sheet that has over 34,000 rows. It has the employees name, payroll date, and time card hours. Example: <tbody> Company Code Payroll Name File Number Payroll Pay Date Timecard Hours PayCode AAA John Smith 0012345 07/26/2018 8.00 Reg AAA John Smith 0012345 07/27/2018...
15. ### MATCHing an ARRAY within a SUMPRODUCT

Hi, I'm trying to calculate a weighted credit score for the credit ratings I have in my bonds portfolio. The first table represents the different S&P credit ratings (column A) and their arbitrary scores (B). The second table represents the bonds I have, the investment in each bond (C), their...
16. ### SUMIF with exact text string in an array as criteria

Hi guys, I have a question regarding the best way to do a sumif of a range containing an exact string which in my example is a single letter. The problem I'm encountering is that this letter also happens to be within words of other cells. How would I go about returning only the sum of cells...
17. ### Alternative to the pivot table

Hello I am searching an alternative to the pivot table. Since the pivot table works only if data are in the same header (column) how can I select a certain type of date for a given reference? Let me explain here. I have a similar situation as below: <tbody> ID Date Value 1 Value2 ID Date...
18. ### Filtering Unique records

My data is as follows...6 columns....Duplicate data in col A and col D....need to be attended to <tbody> AAA xxx yyy USD zzz www AAA USD BBB abc swe INR wed fde AAA CAN CCC CAN AAA INR DDD USD BBB INR EEE ROU BBB SRT BBB SRT CCC CAN CCC MYN CCC MYN...
19. ### IF value is same in two columns then display a third value from another column

Hi, Does anyone know which formula can achieve this: If value in column A is the same as value in column B, then display the value from Column C For example if Column A contains these values C1 - AAA C2 - BBB Column B contains the same: B1 - AAA B2 - BBB B3 - CCC Column C contains C1 -...
20. ### Finding exact text string in an array

Hi guys, I have a question regarding the best way to find the row number of a cell containing an exact string which in my example is a single letter. The problem I'm encountering is that this letter also happens to be within words of other cells. How would I go about returning only the row with...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...