bucket

I have a list of managers (column A), a list of departments that are assigned to these managers (the amount varies) (column B), the final column contains the amount/values of employees in each dept (column C). The purpose of the list is to distribute it to 6 different people. I need 6 different...

Hello everyone, I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is: The total number of applications changes month on month The % of total applications that sit...

I could use some help with how to write this formula in ACCESS to determine age bucket for the column DaysAged. It works fine when I input just the formula for <= 30 days but, when I add 30-60, 60-240, and > 240 it isn't calculating correctly. I'm just not sure how to show the days between 30-...

Hi, I am trying to recreate a pivot table but there is a duplicate base field. Example: 1. Bucket 2. Bucket2 Bucket2 is not in the data source. How do I duplicate the Bucket field in the Pivot Table Base Fields? Thank you for your time!

Hello, I'm trying to use VBA to replace numerous formulas. I am hoping someone might be able to help me with a quick and clean way to do the following based on my example: I want to; -search current worksheet in range (column c starting at c3:c13) -if 'NO' found then mark 'NO' in cell on same...

Dear All, We tracking our order shipment progress on hourly TAT ( Turn Around Time). Example TAT Bucket 20:54 <24Hrs 23:59 <24Hrs 38:03 >24Hrs <48Hrs These times can be starting with 00:01hrs till 8736:30hrs ( 364 days) , currently i am applying these buckets manually ( by...

I have the code below, which is almost an exact copy of code elsewhere in the same workbook; but for some reason, the formula isn't being entered into the workbook. I've stepped through the code, and every line works as expected, except for the formula entry. Thoughts? Sub IDDupBKI()...

Hi, I am unable to upload image .jpg to AWS S3 bucket using vba from my local system to S3. Please do help me. Thanks.

Hello, i have a spreadsheet that i would like to add a column to "E" and name it BUCKETS as the header. then i want it to copy a formula down from e2 down to lastrow that related to the information in column D The issue im running into is that the row numbers are not changing in the formula...

Hi , i have variance % in column A which includes positive and negative %, i have put ageing bucket using this formula =IF(A2<5%,"0% to 5%",IF(A2<10%,"5% to 10%",IF(A2<15%,"10% to 15%",IF(A2<20%,"15% to 20%",IF(A2>20%,">20%"))))) but now i want to add agieing bucket for negative value as well...

Hello, I have the following data: <tbody> Units Min Max Price per Unit 9130 7063 7600 40 7601 8000 45 8001 9200 50 9201 55 </tbody> The total price paid would be the overage in each bucket * the price per unit. How can I write this using a single IF statement? Thanks

Morning All, Long time lurker, first time poster. Firstly thanks for all the help over the years, really helped me out. Has anyone used or arguments successfully (Non-VBA route due to audience restrictions)? I have 2 "buckets" A 4 B 6 C 7 D 1 E 3 F 9 I'm trying...

Hey All, This is my first post on the website. I'm looking to get a vlookup value based on the closest value. I have 3 different buckets with their different numbers. They do not exactly match the list on the left so i'm looking for a formula / VBA loop to automatically show the bucket name...

Hi guys, I'm creating a file that allows me to automatically determine the number of items to assign to a person depending on their current bucket load. I'm having trouble looking for the code/formula to insert that will allow me to do what I'm looking for. Here is my sheet...

Hello, I have some numbers in columns that I want to put them in bucket below. Please help create a formula based on below: Anything above 100 should show greater than 100, abything between 76-100 should show in 76-100 buckets, anything falls in between 51-75 should show in 51-75 bucket and...

Hello, I'm using excel 2013. I have a table that is a log of a product that displays how many days until it failed, date it was shipped, the cause of the failure, etc. There is also a column that buckets the causes by a broader category. ex. cause "broken components" and "broken frame" fall...

Dear Experts, Note: I'm using Excel 97. That's right. I have a huge set of data with a wide range of values. About 800 rows. One column. 0 1 24 56 75 2 8 45678 2 98 33356 32 etc. I'd like to make the table that you need to make the histogram. With counts in the appropriate cells...

Hi, I have an alphabetically sorted list of items (filenames) and want to determine how to divide them across roughly equally sized buckets (folders). The list is constantly changing with new items being added daily. I want to do this for different numbers of buckets to see what the best spread...