district

  1. S

    Excel ADO Select Distinct from2 column with numeric value

    Hi guys Please help... I have data: District; Type; Price1; Price2 JKT; Type1; 100; JKT; Type1; 101; JKT; Type1; 104; JKT; Type1; ; 111 JKT; Type1; ; 22 JKT; Type2; 50; JKT; Type2; ; 150 JKT; Type2; ; 15 SMG; Type2; ; 44 SMG; Type2; ...
  2. D

    dynamic report header

    Access 365 I have a QBF with a combobox "CboGrouping" that tells the report the tow grouping the user wants. (code from Allen Brown) Now I need to add the correct fields in the Header area... i.e. if case 1, then District Header would be [District] and District Header would be [District]...
  3. U

    VBA Generate Reference Number for Sorting

    Hi Guys, How do you create a reference number for sorting purpose in VBA form? Example: On Sheet 1, I will be adding new column in A where will generate a number 1,2,3,4,5,6...etc. up to the last non cell blank cell now in Column B (address details). I will be using it for sorting purposes...
  4. T

    Look up on multiple criteria

    Hello community, I have kind of a noob question here. <tbody> City District Information City (X) District (Y) Urban(1)/Rural (2) 1 2 1 1 1 1 1 1 2 2 1 2 1 3 1 2 3 2 1 1 2 2 2 2 1 1 3 2 3 2...
  5. K

    Best formula for data lookup from Store#, Dept #, and Date from a lot of data

    I have a sheet of sales with 7 blocks of daily data, Sunday to Sat. one block for each day. They are by store, down, and dept, across. I have another spreadsheet report with 34 taps, one for each store. Each with one block for each day of the week. I need to look up values from the sheet of...
  6. N

    Formula to convert text based on commas

    I'm trying to use a formula which would take what's in the column A and convert it to what's in column B. Basically, the entire contents would end up surrounded by square brackets, and anywhere there is a comma, this comma should act as a separator, and finally all phrases separated by commas...
  7. V

    formula to derive district with maximum count

    Hi All, Need a formula to derive the final district by looking at the maximum count. There are duplicate accounts against which there are number of counts, the district with maximum count of these duplicate to be derived in final district column. In event of tie any one of the district can be...
  8. C

    4 dependent combo boxes using VBA

    I've been working on this for a while. I can relate two combo boxes only. Example of my data: Region District Facilities Tangwa Tangwa_Disctict Tangwa_District_Facilities The problem I believe is that Region on has 4 entries, District has 8...
  9. B

    macro to rank a salaries descending

    I have a sheet in a file where I have potential salaries by district office. I would like to sort this list automatically by district (there might be 5, 10, or 15 offices in one district. I have multiple ranges to rank on this sheet). I was thinking about creating a helpful column using the...
  10. J

    Populating Field in Table1 Cell Based on Certain Table1 Cells matching Table2 Cells

    Hi I have two tables (Table1 and Table2) on 2 different tabs (Sheet1 and Sheet2, respectively). Table1 <tbody> Name City Line District James Boston Hard Goods John Los Angeles Soft Goods William Baltimore Soft Goods Harold Miami Hard Goods </tbody> Table2 <tbody> Name City...
  11. K

    If statement combined with VLOOKUP to return specific text?

    Hi, everyone, I'm using a VLOOKUP to determine whether students are listed on a separate sheet which shows that they have a district laptop checked out to them. The VLOOKUP is working fine by itself: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida...
  12. B

    VBA to Extract Worksheets from a single workbook putting each in its own workbook

    I have an Excel workbook with approximately 20 worksheets in it. I want each worksheet to have it's own workbook named as the worksheet tab is named (tab name "District 01", file name "District 01") in same folder. I want to keep the original workbook intact as well so these would be copies of...
  13. R

    3 d map regional map problem

    I created a map with 3 d Map Montreal's uiing open data for 311 calls, I selected a subset for calls regarding calls for rat extermination. The data has geo location for each call. I then tried to amend the tour to a regional map with electorial district by importing a kml file that was also...
  14. S

    Match one value in column and vlookup the rest?

    Not sure if my title is exactly what I'm looking for but what I'm trying to do is lookup a value based on two criteria. The best way to show you what I'm looking to do is to just show a sample of what I'm trying to do. Whatever is in cell A2 (District 3), I want the formulas in column B to...

Some videos you may like

This Week's Hot Topics

Top