pick

So since all pick 3 and pick 4 numbers have different combinations possible, I want excel to highlight them based on how many times each combination repeats. I want to do this for 3 and 4 digit sets separately. Ultimately I want to paste all winning numbers in column A in let's say every March...

I am currently making a spreadsheet where the user can pick a time frame and depending on that selection, a function will sum up the time frame that the individual has selected. Currently, I have two data validation boxes that allow the user to pick the time frame but I cannot think of how to...

Excel 2007. Columns A, B and C : contains dates in dd/mm/yyyy format. Column D : contains number in single digit (1 in some cells, 2 in some cells; 3 in some cells) (Col D only single digit number either 1 or 2 or 3). Example of one row: A1 : 25-04-2018; B1: 27-04-2018; C1...

Hello, I am struggling with the correct formula, I have various sources of data, which contain names in diffferent formats, for example fred Smith and Fred S Smith. I put together the following formula which i though would pick these names differences up within the "*"&'Instructions '!ls&"*"...

Hello All, I'm trying to do a formula that will pick out occurrences between 30 minute intervals, I also want this to be filtered by date however I'm struggling to compose a formula that can do this. So far I have this "=SUMPRODUCT((B2:B101<=C2)*(B2:B101>D2))" this will pick out the...

Hopefully this makes sense... The first sheet we will call "Pick" and is formatted like this: <tbody> SKU Description Call Name BC QTY B/O Aisle Row Tier Truck Stop 1234567 Blah Blah Blah _____ 1 301 A 1 1 1 </tbody> There is an empty row under every entry. The...

Hi all, I have a data table that I want to be able to have drop down's to pick up as a new datasheet is created. My data table looks like this <tbody> Pay Grade Pay Scale Amount Classroom Teacher M1 10 Classroom Teacher M2 15 Classroom Teacher M3 20 Training & Learning TLR1 2...

Hello I am using the formula below to count numbers in column A ignoring any duplicate numbers. I would like to add a part to this to also pick up any blank cells from H2:H1000. Is there a way around this? =COUNT(IF(FREQUENCY('3a6'!A2:A1000,'3a6'!A2:A1000),'3a6'!A2:A1000)) Thanking you for...

Site Index=25, Cell Index=113, Alarm Cause=Other causes, Site Type=BTS3900 GSM, Site Name=SK0029, Cell Name=SK0029C, Cell CGI=621-20-2d6-754d i have the above, i need to search and pick any where Cell Name appear and pick the id in front to a new cloum e.g SK0029C

In column A. I have a list of names and in column B I have a list of dates. What I would like to do is say in cell C1 is pick the last name from the list in column A. Can anyone help please with a formula

I've been racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from. So. Here is what I'm trying to do. Numbers are arbitrary to explain. I have 100 employees listed in seniority order. I...

Hi, so im trying to do an averageif based on if the range contains a certain word, here is how I tried it =AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892) But the word it picks is the word on the same row in column D, so if i move the cell up to 5 for example, it...

Hi all, Fairly new to the forum, however im learning excel at a fast rate. Basically i need help in a "heatmap" im creating for work. We have pick locations in which we pick stock from (obviously). now the heat map lists the location and how many are due to move from it. how i have it is it...

Hello All, I have a formulated table and over 100 workbooks with different names. I would like a macro that will let me pick an individual workbook and pull data from it into a master workbook. Can anyone help? Adrac

<tbody> Status Bookmaker Rating Win Nitrogen Sports Pick of the Day Loss Nitrogen Sports Regular Win TRP Special Pick of the Day Loss TRP Special Pick of the Night Win TRP Special Pick of the Day Win TRP Special Pick of the Night </tbody> Alright, So I am trying to find the current...

Hi, I am familiar and comfortable using Drop Down Lists for data input accuracy. But now I'm in a situation where I'd like to set the drop down list to be dependent on the value in another cell: E.G. if A1 = SUB, then value picked in the dorp down list in cell B1 uses list in are c1:c20, if...

I have the following formula: =SUM(SUMIFS(TSB!$I$5:$I$91,TSB!$J$5:$J$91,{"MA","MI","EQ"},TSB!$U$5:TSB!$U$91,"=MAR")) It works perfectly. MA, MI and EQ are Cost Codes, there could be up to 6. MAR is the Department. There are over 50 rows, each a unique combination of Cost Codes and Departments. I...

Hello, We sell products, and every morning we print a "pick list" (column A has "item#" and Col B has "Qty") and then the worker goes into the warehouse and pick the items. Currently she holds the sheet in one hand and reads and uses the other hand to pick the item. We are looking for a...

I have the following problem: I have one column with integers (from a binomial distribution) to which I will refer as "n". In a second sheet, I have another column of values (from a cost analysis). Now I want Excel to randomly pick n-cells (n = a given integer) from sheet 2 and sum-them up...

Hi, I'm after a code to search column H pick pick up any cells with the value 0. Then to delete the entire row that has this value in them. Any help would be appreciated. Thanks, Wez