data

Hi Mr Excel, How do find Number Pattern in data which is : 1. Starting a Negative value ( - ) 2. Follow by at least a Zero ( 0 / 00 / 000 / 000..... ) 3. Follow by a Positive value ( + ) 4. End with a Negative value ( - ) Number Pattern : - 0 + - When Number Pattern found, assign "1" at...

Context: Pathshala Learning Center (PLC) is a community learning center, has been serving children & youth across 13 villages in the Gular Dogi region (District - Tehri Garhwal, Uttarakhand) since 2016. It has been striving to facilitate an environment of opportunities and holistic learning...

I have come to this weird issue where excel isn't using the target cells for my formula until i double click into each cell that that kind of refreshes it into working. in the example below you can see rows 9,10 and 11 have nothing in column K, however if i were to double click into one of...

Hello-I have a series of power queries that culminate in a large dataset of more than 1 million records. I would like to publish access to the power query as a connection, rather than as a workbook table given it’s large size and growing. In a nutshell, I’d like to allow access to the power...

Hello Wondering if an Excel expert can help. I'm wondering if this might be due to an update but i'm not entirely sure. I have a workbook at work which is used to track absence. There is a master data sheet which is refreshed with a system report every day, so on the absence sheet, all the...

I am trying to make a data validation list on Sheet1 that references all non-blank items in column A on Sheet2. I have accomplished this pretty easily (although, is there a way to exclude the header without just selecting a long range like "A2:A5000"?). Now, I want to trim that list to only...

Hello! In QR we have an enter after each row, which works fine in notepad when scanned with barcode scanner. But in excel it just outputs one string and sounds an windows "error" sound when it's supposed to output the enter. Doing the exact same thing with tab works just fine, no issues, it...

Hi Excel Experts, I am looking for one small automation macro to filter the data below and need to keep one set of data from the input to the output. We have three columns below and Col-1 where "Y" is applicable in Col-3 then Col-1 cell value should be base and corresponding Col-2 data...

Good Day Everyone, I have a Bit of a Funny Issue that I'm not Sure what could be Causing it, as it Only Happens to One User while the Rest is Fine. I have a Template that is Used by 5 Data Captures in the Company, Very Simple, on Sheet One(Data) I have the Data Range to be Used in the Dropdown...

Hello excel experts, I have annoying (crappy) data, and I am trying to grab all names from a column that meets a couple criteria. In that column are subtotal rows with a count of names and a TOTAL heading, and category headings like: - 2020 Sold Properties - 2020 Completed Refi - 2021...

Hi everyone! I have a spreadsheet to convert the (attached picture) in green to rows in yellow. Is there possible formula or code to create the remining data from rows 7 thru 24 to columns L thru V) ? Here is steps example for manual input (to convert green row 2 into yellow rows 2, 3 and 4)...

Hello, I have an absence tracker which records absence in a current 6-month rolling period and a previous 6-month rolling period. Each occasion of absence is recorded as a separate row and absence is manually added to the "current 6 month" sheet daily (as it occurs). A piece of VBA code then...

Hello, I use the below code for my absence tracker which was kindly provided on here. I now need to change it, so instead of looking at current 12 month rolling period and previous 12 month rolling period, it looks at: Current 6 months Tab - All absence in the last 6 month rolling period from...

Hello I would like to ask if and in what way it is possible to create a specific print report in excel. I need to print data from Excel in a specific format, where each cell in the column has a designated specific place in the document - from one line in Excel, make 3 on A4 in the printed...

Hello, I am struggling with quartile formula to calculate the selected value in another tab based on the description and grade. In the workbook I have one tab with all the data range based on description (i.e. Maths - A, B, C) and in another tab I need to calculate 3rd quartile for grade A, B...

Hi, I had a question. I wanted to convert non-uniform data in single Excel column to uniform data into another column. Example- I have an Excel column containing values as 345.12 million, 128.56 billion, 2.67 trillion and I would like to convert this non-uniform data into a uniform way using VBA...

I want to merge files "Data" which are in "select input folder"button and "select output folder"button into one file Both the files "Data" Should Merge When I click Execute button Is there any macro to dd?please help me out

Hi all, I have raw data that I want to convert to be read easier. There are lines open between each statement. 1. I would need the payment date(M67) to be pasted in every row in column K(In photo - K75 and K76) for the transactions 2. I would need the Internal code(C68) and code(C69) to be...

I am trying to write a code using Selenium Basic. I am extracting messages from a messaging service. I can extract all the messages using FindElementByClass, however this returns all the messages and does not contain any details of who the message is from. I need the messages returned to the...

Hello, I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values. I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value. Any help would be greatly appreciated...