pick

Hi, Need help with a formula that will find the top 3 in a table and place the item in cell before. In bottom table, D will have formula that will pick up 420, and C2 will pick up SQuash, then D3 will pick up 325 and C2 will pick up Okra. and so on. I found how to use =large to pick up in order...

hi Friends, please help i am not very much familiar with VBA Need help with the below code this is being used for Random Sample picking tool, Currently set to pick 10 accounts for evry users, now i need to pick 10% of Users productivity, the higjlighted part shows slecting 10 and from...

Hi I have since 1999 downloaded statistics in XML format from a home page and now they have changed to JSON. I can't write code myself and wondering if anyone can help me with VBA code that can pick out details from this file and print the details in a text file. I keep my fingers crossed that...

Hi, good afternoon I would like to copy what is highlighted in my combobox which is in my userform1 i have tried the formula below which i have put in cell M1 but it doesnt pick up anything from the combobox can you help me please? =filter!UserForm1 ("ComboBox1")

Hello All, Need some assistance. I have a spreadsheet with duplicate numbers (3 rows). Each row for that duplicate # has a phrase such in Column Code as Hardware, Removed, Resolved. If I have duplicates how do create a formula to pick up the word "Resolved" for the duplicates? Thanks in...

Hi All, I new to vba, I need the code for random sample pick based on criteria <tbody> Name Process Group Nickels MT Red Tiffany MS Green COLEMAN MQ Yellow Tomas MT Red Hill AQ Green John MT Yellow </tbody> columns A has Name columns B has Process Columns C has Group like that i...

Hello, I currently have the following: Private Sub TextBox9_Exit(ByVal Cancel As MSForms.ReturnBoolean) If TextBox9.Value Like "*[!0-9]*" Then MsgBox "You must provide a numeric value in this TextBox!" Cancel = True ElseIf TextBox9.Value > 2 Then MsgBox "Invalid Pick!"...

Hello, I currently have: Private Sub TextBox3_Exit(ByVal Cancel As MSForms.ReturnBoolean) If TextBox3.Value Like "*[!0-9]*" Then MsgBox "You must provide a numeric value in this TextBox!" Cancel = True ElseIf TextBox3.Value > 26 Then MsgBox "Invalid Pick!" Cancel = True...

HI Ihave a set of data (see below). I want to count “YES” and the more “yes”supplier have the darker colour the result it should be ( in this way I canshow which supplier I should pick) Icouldn’t figure out a way. The only thing I can think about is percentage. Cananyone help me to find a...

If a particular date is a Saturday or Sunday how can i flag this to pick up the next working days date i.e. the following monday

Hello, I'm doing a fantasy football draft soon and I'm trying to find a way to automatically have the pick number appear in a cell next to each players name (Pick # column) after I enter their name. Each time I enter a new name the pick number should go up by one. I will be using five different...

Hi all - have been trying to write an IF with VLOOKUP nested statement. I would like to look at the first table where the PICK column is negative (TABLE 1) and vlookup the next table to see if stock is available.(TABLE 2). Then reverse the process later from table 2 to table 1. I have over...

Result : The result going in a new sheet. Criteria : only two criteria from A2 and G2. H2 is sheet name from which data will be searched and F2 is number of rows which should be picked. Searching : I will be searching in a sheet with multiple columns. The column of A2 and G2 will be same in that...

I am trying to group some rows. When I group I don't see the plus or minus area I just see a white line. See the attached pick. I have checked the Show outline symbols if an outline is applied and I still see the white line to the left. See image. Thanks I can't seem to add a pick.

Hello, just after some help with one element of my coding, all the rest works. I have effectively built a hierarchy of conditions for rows on a excel spreadsheet that i want to populate a summary tab. all works fine apart from this element, which does not error, it simply does not pick up...

Hi guys, I have written some code that looks at a database and filters on a user number and then pastes the data onto worksheets (named as the user numbers) - all of this part is working fine - I have created a very simple array to store the user numbers. I have some additional formatting for...

Hi All, I have some data from column R to column CZ. Row 1 contains the Headers. Now I need to look for last non-zero value and pick the header next that cell. I am using the below formula right now but its not giving me the next header. its giving me the header of cell where last non zero...

I need to create a formula to pick up the next 3rd day of the month. For instance, today is 5/9/18 so I need the next date to automatically update to 6/3/18. However, I seem to only be able to pick up the current's month date of 5/3/18. Please help! Thx!

Hello all I have made some basic code in VBA to generate 2 pivot tables. This works :-) I have then converted the pivots to values in order to consolidate into one report. However, I want name the ranges or at the very least in the data consolidate box allow for it to pick up the current...

Could someone please tell me if it is possible to do the following?! I have a row of dates in Row 1 - A1 being Friday 1st May, B1 Saturday 2nd May, through to G1 being Thursday 7th May. Row 2 is a row of formula to pick details from another worksheet. Row 3 is the next week's dates - A3 being...