order by

  1. G

    INDEX and MATCH formula

    I need help creating a formula to look up values in order in the rank column in the table on the right, and pullover the Group A country onto the table to the left. The idea is that I hide the table to the right that is calculating scores based on another area in my spreadsheet, and I will use...
  2. R

    Display contents on form by sort of dropdown list

    Hi All, Quick question (probably very basic... so apologies in advance) .... I have an access form used by reception, it registers: - caller name - caller phone - who they want to speak to (dropdown list of names) - brief message of content of call If my name is one of the ones on the drop...
  3. J

    Ordering file read in via ODBC

    Hi, An awkward problem here I suspect! Creating a pivot from a text file, read in via ODBC. This works fine, so naturally they want to change it :rolleyes: Currently: Set objMyPivotCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal) With objMyPivotCache .Connection =...
  4. P

    Need help with ORDER BY SQL syntax

    Hello, I have built a crosstab query to calculate a sum for a specified date. ACCESS automatically populates the query alphabetically by the "CourtTimeSaved" column, however, I want a different ORDER BY list. How may I do that? TRANSFORM Count([Court Time Saved].ID) AS CountOfID SELECT...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top