aaa

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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