multi

  1. L

    in PQ can we merge multi sheets in Multi Workbook at same time

    Hi all i have 5 files for 5 regions each files contains From 4 to 10 sheets ( each sheet for Product sales Anaysis ) i merged it by my PQ File file then i use PQ also to Merge it all in one file that is mean i use PQ 5 times for 5 files then i use it again to merge it all in one file can...
  2. A

    multi criteria multi result lookup

    trying to adapt https://www.get-digital-help.com/match-two-criteria-and-return-multiple-rows-in-excel/ to work for me. my version of the formula is: =INDEX($AK$7:$AK$15, SMALL(IF(COUNTIF($AG$5,$AJ$7:$AJ$15)*COUNTIF($AG$6,$AJ$7:$AJ$15)*COUNTIF($AG$7,$AJ$7:$AJ$15)...
  3. Skybluekid

    Multi Level Category Graph

    Hi All, Are able to produce a Multi Level Category Graph with Power BI?
  4. R

    Multi level sort on a dynamic range

    Good afternoon...again. :) I'm surprised I can't find some already built code on how to do a multi level sort on a dynamic data range...but I've not found any so far, so I have to bother everyone here again. My header row is on row 7; I have 7 columns, and I need to sort first by column B...
  5. B

    IF(AND(OR multiple step fx including positive and negative integers

    <tbody> w x y z aa 8 251 -108 159 9 -231 118 -149 10 </tbody> What is the correct way to enter the following multi step fx to satisfy the following: In cell Z8 = IF W8 is > 0 AND X8 < 0, OR IF W8 < 0 AND X8 > 0, AND X8 <=-150, THEN 1, "" In cell AA8 = IF W8 is > 0 AND X8 <0...
  6. S

    copy the contents of a multicolumn listbox to a single cell on a worksheet

    Is there as way of sending the contents of a Multi Column Listbox to a single cell in a worksheet. I am currently using the following code to send data from a Userform to Worksheet, but for some reason the data from my Multi Column listbox does not transfer over. The data is a combination of...
  7. H

    Color on Multi page in User form....

    Hey Excel Guru's I need some Help to change Colour if Multi page is Activated By Double-click on Specific cell.... All the Function with Double-click works it's the Colour Part i need... example I Double click on Cell "B1" then the Multi page side Should Change Background - Colour So that...
  8. J

    Show & Hide Rows - Depending on value (Automatic Change, buttonless)

    Hey people, Just started using vba and this site has really helped me! So I thought I'd try asking with this; I'm wanting to set up a page on excel so that when B15 reads a value, it reveals the corresponding amount of rows on the page. The Values in B15 are drop box selections of: - Single -...
  9. S

    Excel macro to find all that match key not just the first when looking for differences

    I am trying to compare two file. I receive a file once a week. And I need to compare last week’s file to this week’s file. I have them both in the same file on two different tabs. One called Old and the other is called New. I need to look at these two file and see where the Location has...
  10. A

    Salary - medianifs and quartileifs in excel mac

    Hi, I'm trying to calculate the median salary based on a set of conditions - job code = 42, school type = single site. Sample data: <style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in...
  11. Skybluekid

    Dynamic Multi Level Column Graph

    Hi all, I am after a way to create a dynamic multi level graph, without using a Pivot Table. What i would like is the graph to change, when selecting the month, to show category, depot, fine type, Registration. I have no issue in creating a static multi level graph, but as the data changes...
  12. A

    How to select a particular line in multi line text box

    Hello All, Need help on how to select a particular line in multi line text box. I have a text box with multi line which contains several line with name of countries. I perform single click on one of the country and expect that particular line will be highlighted. Followup action will be delete...
  13. 3

    Multi select macro running slowly

    Hoping someone can help with my first attempt at a multi select macro. The single version runs in less than a second but using this code to multi select it now takes up to 5 sec for each. Figure it is something to do with how I am getting them from the array. vaFiles =...
  14. M

    Multi Sheets

    Hi I am using the following SUMIF('01012019'!$I$1:$I$1000,"GRID",'01012019'!$F$1:$F$1009) I need to pick up info from each tab on my sheet dating 01012019 to 31012019. my question is : Is there an easy way to do this ?? Or would I have to go into every sheet. Thanks
  15. L

    multi column address data base i would like to break down

    I have a large multi column address data base i would like to break down into county groups by loading in lists of the individual municipalities. how do i write a reusable function/formula in excel that mimics this query? "city" contains Arkport OR Atlanta OR Avoca OR Cohocton OR Dansville OR...
  16. M

    multi item drop down items and non-multi item drop down lists on the same page

    I have multiple cells with drop down lists created using data validation. I would like some of them to have a multi item option and some to be single item choice. The VBA code I am using is applicable to an entire sheet and makes all of the drop downs multi item. Is there a way to specify...
  17. Trevor3007

    Run VBA

    hi i have taken ownership of a workbook . I need the VBA to run upon opening the file can someone advise on how to do this? I thought I just had add the applicable into 'thisworkbook' but it does not run upon opening:banghead: MTIA & KR Trevor3007:cool:
  18. Trevor3007

    multi attachements

    hi is there some code that will all to attach multi attachments in one go (normally would select items & copy ) for outlook. At the moment the VB I have/use only allows 1 at a time to be attached! MTIA & KR Trevor3007
  19. A

    Userform multi tabs

    Hi all I am unsung Excel 2013. I have an userform with textboxes. I have created some multiple pages underneath the main userform textboxes. However when I click the tabs in the multi pages, the screen moves and only shows the content of the multi pages. I would like to keep the main form...
  20. L

    Mode.Mult in dynamic table, excluding zeros, and hiding errors

    Hi, I have a table that updates as data is entered into another sheet. I want to find the mode of this data, but exclude the zeros, since there is a lot of zeros, because data has not been entered into the original sheet yet. Here is the formula currently being used...

Some videos you may like

This Week's Hot Topics

Top