data

Hi all, I’m not entirely sure if what I’m asking is possible and it’s fine if not (I’m at loss), I just want to exhaust all options before I say “It can’t be done”. We have an MS Form with say 10 questions. Due to changes the form has been removed and a new one published. It has now increased...

Hello everyone, As part of the Olympics celebrations, we've created a couple of trivia quizzes using MS Forms for colleagues. Each MS Forms quiz outputs the results into an excel spreadsheet. From the outputted spreadsheet, the main info I need are: Name The points The amount of time each...

NEED FORMULA TO CATEGORIES FROM DATA. IN COLUMN A DATA ARE THERE WITH THIS DETAIL IN IT AND I WANT TO CATEGORIES IN COLUMN B. PLS HELP WITH FORMULA I TRIED WITH IFS, SEARCH BUT GETTING ERROR. AB1INV AB 001-24-25INV2PAYMENT RECEIVEDPAYMENT3RECEIVED MATERIALMATERIAL4PART PAYMENTPART THANKS IN...

Pls help me with formula for extracting data according to criteria. I want to extract data from column A to column B, C, D respectivly. Pls note sometime there are 2 or more space in data ABCD1ORDER DETAILCLIENTORDER #DATE2CLIENT : MCDOWEL ORDER # 7259 DATE : 01/07/2024 Thanks in Advance...

Hi Guys, I would like to process data that is now in large numbers on rows. Some of this information I would like to have in rows below it. Columns A through C contain product names+info and columns D, E and F contain data. The latter data I would like to have below each other, as I indicate...

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

hello Im trying to build a data base of parts warranty info. what im looking to do is when I select a part number via drop down menu in the 'part number' column, the corresponding description and cost columns in the same sheet are automatically filled in. my image below... the PN# column is a...

I have provided the screenshot of my excel worksheet. I want to rename the cells in column B chronologically same as Column A but without losing the blank cells. i.e the first "transfer" name cell of column B will be "transfer 1", the second "transfer" name cell of column B will be "transfer 2"...

Hi Using PowerQuery I want to transform the first table into the second so that every 'Number' in a 'Region' shows every 'Location' in that 'Region', with multiple rows per 'Number'. This is just dummy data. I have tried doing this with pivot/unpivot but struggling to get my head around it...

Hi all, So I have a table similar to the below which acts as a matrix, so Req ID 1 is in F1 but could be in any number of Fx, up to about F80. The status of a Req ID can be updated The Team X is the team who is interested/working on the particular Req. Req ID Status F1 F2 F3 F4 F5 1 Agreed...

Hello! So my first problem is as follows; When I make ticket purchases these are given a purchase number from my supplier & a quantity, for example; Purchase number; 34598 QTY; 4 I then use a simple Vlookup formula to filter through which event this ticket is attached to. Once those...

Hello - I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use. The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...

Dear All I have a file with 65 different course I'd with status and level as column header and employees details as rows. What I want is to change this horizontal structure to a vertical one. There are a total of 300+ employees. I need the employee details as it is in the rows but repeated for...

Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...

Hi all, Whenever I open a csv I get this warning message: Furthermore, my data shift's over to the right, there is an example below but the issue can be random - it may add lots of different empty rows and shift a few rows over to the right, or sometimes the data overlays the rows on top of...

Short version: I am trying to change the code below, so worksheet 41460 can be any Excel file in a certain folder: Further explanation: I have more than 100 Excel files in a single folder, all with the same format. Column A contains a unique number. In one document, there might be 10 of these...

Hi I can't XL2BB as my work won't allow it: I need a VBA code on workbook open to sort these three columns (not the total) by days lost > highest to smallest. A small caveat here is that the VBA will need to first unprotect the workbook (with password) before sorting the data and then...

Hello, I have multiple workbooks and they have approximately 25 sheets in each of them. I need to extract same data from each of them. The data is always in the same cell and sheet. I need to extract data to one new workbook. What is the easiest way to do this? EDIT: Also I need to extract...

Hi guys, I am working on a project for my work which is a form that users can use to help them make decisions etc. I have this code that provides the ability to make multiple selections from a data validation list, so instead of the default excel position of being able to select one option...

Hi all! I am using a data scraper to pull info from the web and an struggling to transform it in a way that's easily read. Right now the csv file comes out like this: Title - data Title - data Title - data And then it repeats in blocks like that. What I want is to move the titles into the...