data analysis

Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...

Hello everyone, First of all, I would like to mention that I'm not an expert with Excel. ? So, I have a column with two different units (GB and TB): Space PV 104.10 GB 1.7 TB I will need this values to do some calculations, but I can't do nothing because I need to replace: "." for...

Hello, I need help summarize list on people ordering which items. I currently have 50 lists of items and more than 100 people. I’ve done most of the part but it’d be nice if I can show which person order which item and how many in a different sheet. Please do help me.Thank you

Hi, i am doing a class project for a company i work for that wants to know which customers are returning pails( pails product name in Column "ProdName" as shown in screenshot),and at what rate? The columns I am focusing on is customer name, product name, and removal date. There's thousands list...

Dear all, I'd like a stacked bar chart that is displaying each category in a given color. The colors are given in the file attached. As an example I have added the image below. I would like to have one stacked bar chart (not one above the arrow and one below) with a timeline at the bottom. Is...

There are a few standard ways to find the area containing data in a worksheet, but each has a problem. 1) Activesheet.Cells(1).CurrentRegion won't work correctly if there are blank rows or columns 2) Activesheet.Cells(Activesheet.Rows.Count, 1).End(xlUp).Row won't work correctly if there is...

Hello, I am trying to create a matrix of constituents in our database comparing their Relationships to other constituents. I have a list of constituents, and each one has a list of people they have relationships with (represented here are constituent IDs for people attached to their record as a...

I am trying to apply data bar individually for every Field in PivotTable Like this : I was trying to create a code to start new datarange for every active field, but got stuck with this. Dim pt As PivotTable Dim pf As PivotField Dim pi As PivotItem Dim pfs As PivotFields Set pfs =...

Hi Guys, I have a big favour to ask. Within excel there is an add-in called “Data Analysis”, Which can do “Regression” I am able to get the Coefficients using the following formula as an array (if the ranges are set to be the independent and depend variable data)...

Hello Everyone, I have excel sheet with data as attached screenshot. Data is in three column - Keyword, Search volume, competitor. "Keyword" column has every two values are same but their values in "search volume" & "competitor" are different or same. I want only one keyword in every two same...

Hello, I have a situation that I'm looking for help on a formula that seems to be stumping me. The data that I'm working with are members accounts but what I'm specifically needing to pull is members money market accounts which would be referenced as Item #'s 7, 8, and 10. The two columns of...

Hi, I have an idea about how I want my spreadsheet to work but I'm just not sure about the best way to go about it. As I will be arranging large volumes of data, I would like to keep it as simple as possible and avoid too many IF Statements which can cause the file to get too big. Can you...

Hi all I have extracted sales data into 2 columns as below: <colgroup><col style="mso-width-source:userset;mso-width-alt:4059;width:83pt" width="111"> <col style="mso-width-source:userset;mso-width-alt:2852;width:59pt" width="78"> </colgroup><tbody> 15/06/2019 12:55 £15.00...

Hello, I have a large population (30k+) of amounts which contribute to the total amount in another table. I was able to pull the two data-sets together, so I can see in one table the whole amount and all of the individual amounts. The issue is that for a given unique identifier (e.g., 12345)...

Hi, I require help as I have a tried a number of options found in the forum but none seem to work... This is what I need to happen - the person completes the User Form. Once they submit, I require a search to happen to see if it is a duplicate entry (First name, Last name and user ID already...

Hi, Wondering If anyone can help me here? I have 240 different work books that I need to copy into an existing separate workbook table. Each workbook I specifically need columns A - Y, Rows 12 - 25 and also Columns A - Y, Rows 29 - 41 to be copied underneath one and other into a separate...

Hello everyone, I am a long time lurker and excel novice. I have a data set that has multiple entries per date and per group and I would like to combine those entries into a single line. I have given an before and after example below. I am hoping for a VBA solution so that I can save it as a...

Hi All, Just need some advice, I've done some research and I can't seem to find the right answer, I'm getting to the point where I don't believe there is a way to do what I'd like in excel unless it's manually. I'm looking to compare 2 lists, a customer list (20k records) and a supplier list...

Hi, I have a lot of data sequences I need to statistically analyze. The problem is that the numbers are separated by a space character. I need each number to be in a different excel cell. Is there a way to tell excel to use the space as "move the next number to a different cell"? For example...

Goodmorning, Since a few days im trying to get data from my PLC. I fixed to get 1 data unit from the plc and place it in a cell (A1). Ive got this working with the programm UniDDE. This is a connection between the PC(excel) and the PLC. Now when there is a new incomming data the last data will...