picked

Hi, I'm looking for some help in building a dynamic list from a range with multiple constraints without using the Excel standard filters (I'm trying to improve my hockey pool performance by drafting faster and more efficiently!). So basically, I have a list of 800+ players with different...

I have no toolbars in my VBE screen. So I can't right click on them. I have tried everything I can think of, including a complete reinstall. After the reinstall the exact same problem was there - so it must have picked up some settings. Please can anyone help, either with suggestions on how to...

Hi - Is there a way to search folders to open by matching just a partial folder name. For example: I want to use cell C1 as a reference for the folder name. So while C1 has the text "Peter Piper Picked", and the folder on the drive is titled Peter Piper Picked (12 Pickles), it would still...

Hi guys, I seem to be having an issue getting excel to calculate properly. I have a table showing: Picker name(Col B) the time spent picking (Col C), units picked per person (Col D) and want to work out a pick rate(Col F). <colgroup><col width="160" style="width: 120pt; mso-width-source...

Need Help with the following Dates. i have a a file but cannot attach i have copied the table below hope. <colgroup><col><col span="2"><col><col><col span="3"><col span="2"></colgroup><tbody> A B C D E F G H I J 1 Allocation time last picked time time and date needs to be ready picked...

I'm part of an organisation that is altering the way it manages a waiting list, and we have decided we want a way of picking n people per year to join. However, we don't want this done on a first-come-first-served basis, nor do we want an entirely randomised selection, rather a combination of...

Hi, I was trying to build a table that have a unique account number in the left and according to this number its looking for this number in a tab that was chosen from a drop down menu in the top so for example if in cell G3 I picked Act18 , it will sumifs things in tab called Act18, if I picked...

Context: I work inventory at a rebar fab company. I have this report that uses a userform to make tables that show the loads the mill has ready to be picked up. Then this compares these to what we have ordered for the specific cycle (to make sure we get everything we ordered). Now I am...

Hi guys I’m working on a sales tracker for work I’ve it a formula for a cell that when an option is picked from a drop down menu it displays a price However when no option is picked it currently displays #N/A and this is stopping my formula from calculating How can I get it to display a £0.00...

I am trying to find out what cells in a column are picked up in a formula elsewhere (in a different tab) and what wells in the column are not. Is there a way to use conditional formatting to color code cells that are picked up by a formula and what cells are not? Thank you.

I am trying to find out what cells in a column are picked up in a formula elsewhere (in a different tab) and what wells in the column are not. Is there a way to use conditional formatting to color code cells that are picked up by a formula and what cells are not? Thank you.

Hi experts, I am working on a file where some data is picked from one sheet to other by using vlookup function. Hyperlinks are not being picked automatically in other sheet. In Sheet 2 A1 consists of drop down list from Sheet 1 B5:B6. In B3 below formula is used...