ranges

Hello to all who might be able to assist me and my colleagues with this. I am trying to find a way to split the ranges of numbers apart and to get each individual number that would be in that range. For instance, some of the data I am working with is: 120751.120754 120760.120764...

Good Afternoon Could a formula be created to count occurrences of values in ranges and list the occurrences at the conclusion of values in column a. example - looking for a total count of Crits would find 2 values that fall in the Ranges value of 900-1000 [the ones showing 1000] Next looking...

Let's say I have random numbers from 0.00 to 2.50 in columns H and I indicating a range. For each row, column J is supposed to tell me how much of that is within certain specific ranges of between 0.00 to 0.29, 0.79 to 1.29, and 1.79 to 2.29 For example H1 is 0.25 and I1 is 2.00 then J1 is...

I've got an inputs tab and 3 other worksheets in one wkbk. On my inputs tab, i've got cells I2:I14 that have column letters in it (A, AB, N, E, etc.) - these can be changed so they are variable. They correspond to the other worksheets within the wkbk. So 13 cells of columns to ID while...

All the code I've found for removing worksheet defined names is similar to the code below and requires the name of the specific worksheet: Sub RemoveWsRangeNames() '7-21-22 Dim rngName As Name Dim ThisWb As Workbook Dim ThisWs As Worksheet ' Set ThisWb =...

Hi, i've got a code that works - kind of. It does run, and it runs at a good speed. Only problem is that it's not kicking the right rows... High level explanation: I've got sheet A with all my data, it goes to sheet B to see what qualifier to use and then finds it in sheet C which ones have...

I generate a sheet every day that has 4 activities and associated data. I need to capture the MIN and MAX as part of the requirement. that is easy manually but how can you automate this every day to account for a different Activity range? In my example sheet, Activity 12 is rows 22 thru 25...

I'm running into a Range of Objects Worksheet Failed Error for some reason and I cant understand why. All I did was add the following code to the set of ranges in the Target Range in the sheet code, and all of the sudden I'm having errors when entering text into the any of the cells within the...

Hello All, I currently have a workbook with 3 sheets Sheet 1: I use the =FILTER() Function to filter the data into only 3 columns for better presentation. Each set of data (the three columns) is presented in Cells A7:C100, D7:G100. I7:K100 etc. The last set is on GK7:GM100. Sheet 2: Is the logic...

Hello! I'm looking to copy an entire row from one worksheet (Sheet1) to another (Sheet2) based on multiple criteria. For example, in the image below, I need to be able to find all the "Green" fruits and then refine that further to only "Medium" Size. Then, I need to copy the entire row (as long...

Hi All, I'm new here so apologies in advance if I overstep on the etiquette or for showing my ignorance. I am really hoping you can help - my specific problem is as follows: I have text data in merged cells on columns B to D for each row from 200 through to 213 (so 14 rows total). I would...

I have a problem that I'm sure there is a formula that can perform this function. I have a list of numbers, some are consecutive and some are outliers. I need to take this data and create a "From" "To" column on those numbers that are consecutive. Below is an example of the data that I have...

I download a .csv daily In the columns the following headers, Meter, serial num, value, uom, day, wk#, timestamp, and a few more rows of usless info. the meter name changes, the serial num, and the value changes. I added the columns for day, and week# in to make it easier I though. I use the...

Hi All, I am hoping someone could help me. I have some data that I have plotted the averages of as a line graph: My supervisors would like me to add whiskers/error bars based on the range from the data: B-SC IR-SC SC-IR SC-B Initial Inoculum Average: 7.95E+07 Range: 7.90E+07 -...

I have a macro for listing all name ranges in active workbook when a certain worksheet is activated. the code is Sub Rprt() Dim nm As Name, n As Long, y As RANGE, z As Worksheet Application.ScreenUpdating = False Set z = ActiveSheet n = 8 With z .[a5:O155].ClearContents .[a7] =...

Good morning, I'm using the below formula to display the oldest date in a range (to the end of the month) if there is a % value in a designated cell range. =EOMONTH(MAXIFS('FA Afford'!I22:I33,'FA Afford'!E22:E33,">0"),0) In an older version of the document I'm using (where the cell ranges...

Hi.. I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells. the demo file is at below link, and also one small explanation of my requirement. Kindly help... Thank you in advance...

Hi all, I am having trouble with the consolidation of my named ranges into the one pivot table to finish a dashboard. I have got all the named ranges into the data source. Each named range is the same shape: that is, each consists of 4 columns. Columns are Amount, Animal, Location, and Colour. I...

Hello, How would I go about making a graph which plots a number of bars (representing ranges) and lines on the same graph as per below: I would like the lines (which represent the 5th and 95th percentiles of the ranges) to intersect the range as shown in the image. Any ideas?

I started using the INDIRECT function to create a super dynamic Sumif that references a named range based on criteria. However, I noticed that my calculation time has increased significantly since taking this approach. I read online that this is a very volatile function that performs slowly...