zone

  1. O

    Display a list only with the values by country

    Hello everyone, I asked a question in the past, but there are some changes here: The table above has data for each country - as you can see - there are a number of missing data. Cell D16 has a Data Validation list of all countries I would like to know that if I select a particular country from...
  2. A

    Lookup with multiple criteria

    Hello all, I'm trying to find a value in an array using multiple criteria. Basically, what I would be looking to achieve in the below example would be to search for A2 in E1:E4, where B2 is also greater than G2:G4, and less than H2:H4 and return the answer from F2:F4 This should output Zone...
  3. P

    Search for a value with two criterias

    Hello all! I have a project with a client and I would like a slick solution instead of what I usually come up with, which is bulky and slow. I am calculating a shipping price, where i have the zone and weight of the container. This held together with destination country should give me the...
  4. S

    Index/Match for Nonblanks

    Hello Everyone, I'm designing a sheet that is to be used as a tally for a strawman poll before a real vote is held on some projects being considered at my company. Some of these polls will have comments on them when returned. I'd like to list all comments, though most will be blank with no...
  5. R

    Creating Dynamic Calendar

    I'd like to put together a sheet that builds a calendar using data from a table. AND that "translates" the appointment time into whatever local time zone the reader selects. (I'm happy to hard-code the options on the main table.) Here's the deal - I will be traveling in one country while my...
  6. S

    Creating variables for file path names VBA

    I am writing coding for a rather large macro and I am trying to decrease the number of characters I use. One way to do this is to define a variable for the long file path name but it is not liking it. My coding is: ' Ask user for the period of the projection exercise PNumber =...
  7. N

    sorting to other worksheets

    Hi all Every week i get a new report with over 600 employees. Each of them are asigned to a coach. (Column I) I have to select them and make a new worksheet per coach. So that every coach has a clear list. How can i automate this so that i can put the report on sheet 1 and that it...
  8. F

    Macro VBA to match zones based on certain conditions

    Hello to all, I have the table below. Maybe someone could help with this with a VBA macro. I have an Array formula that ouputs almost correct the desired output, but not completely. In column A I have the Country Codes values and in column B corresponding description for each value (ZONE)...
  9. R

    Help with a Count formula with multiple criteria

    Hello, I am trying to get a count multiple criteria. I have an basic example of my spreadsheet below. I want to know how many adults were present within each zone. How would I count the number of adults have yes in column B and then get a count of the adults who have yes in column b by zone...
  10. Q

    How to group data into ranges in Excel

    Hi, If I have a set of repetitive data i.e. individual data points which fall under the same range cell, is there a way to group them together in excel. For eg. All the below data fall under Zone 6. Is there a way I could club all the numbers together for ease of reference. Something like...
  11. Q

    Incorrect value picked up in Vlookup across multiple columns in one formula

    Hi All, I was trying to vlookup my data from a table with 4 columns, when I applied the following formula there were errors in a few of the calculations. IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing Chart'!$B$4:$I$34,2,1),IFERROR(VLOOKUP(LEFT(A4007,3),'USPS - Zone & Pricing...
  12. K

    Vlookup, with ifs and nesting

    I am having an issue with finding the correct syntax to utilize the vlookup where two criteria are met if the first vlookup returns no data. so I was thinking something like find host on datatableA, - if there is an address value (not blank), display it; if not, then look for the host {still on...
  13. U

    Select Case with criteria for two different columns

    With reference to https://www.mrexcel.com/forum/excel-questions/1080840-vba-extract-cell-data-based-if.html Hello. I am working on domestic heating sensor data. See a sample Worksheet with my desired results shown in column "G". The raw data is in columns "A" to "E". When column "D" = 2...
  14. P

    Two Dynamic Combo Boxes

    Hello All! Thanks for reading first off What i want to beable to do is have two combo boxes on a form which when i select a Zone then the second combo box only shows details assoicated with that Zone. I have looked at this video on you tube https://www.youtube.com/watch?v=pMiJHhjzC8Y With...
  15. T

    Production Line Calculations.

    Hi, I am looking at resolving the issue below. Can anyone help? Shipping work has been printed off and you have the line volumes for each work area, but the labour planning tool is not working. You have a 45 minute window (3 cycles) to process these orders before they need to be handed off to...
  16. T

    how to change pivot fields dynamically?

    Hi, I am looking to change the pivot field rows based on a selection from a drop down. For example, I have a pivot with Zone (North, South, East, West), City and Sales. The summary table picks up data from this pivot. The user can select whether he wants to view the summary by Zone of City...
  17. J

    If and vlookup formula

    I need help on constructing a look up. In my spread sheet I will plug in the service type, zone and weight in three different cells. I need it to go to a table that called rates and find the rate based on the info found in the table. example of the table below. <colgroup><col><col><col...
  18. I

    Listing of numbers within different postcode ranges given in one column

    Help please, I have a listing of postcodes in a col. A with some of them given as a range. Is there a quick way to list the postcodes individually in a separate column within that postcode range given and match the corresponding zone associated with it. Example: POSTCODE ZONE 200-203...
  19. D

    Extract unique values across rows and columns

    I have a sheet that looks like the below (except 4k rows and between 1 and 79 columns) I would like to extract all the unique values into one row or column so I can see what all of these unique values are. Removing duplicates does not seem to be working. <thead style="margin-left: 0px...
  20. B

    VBA Help pulling data from website

    Hi all and thank you in advance for any assistance. I'm in over my head on a project and looking for some help/guidance. I want to pull information from a website based upon the information input into my worksheet. A1 = OriginZip A2 = DestinationZip A3 = Zone When zip codes are entered in to...

Some videos you may like

This Week's Hot Topics

Top