1. G

    Choose function under the filter function isn't working properly

    I am using excel365 online and but have excel2016 downloaded onto my computer. I am getting error messages but not sure why. The formula that I have is as follows: =FILTER(CHOOSE((1,2,3),'Employee_Name'!A:A,'Employee_Name'!J:J,'Employee_Name'!B:B),'Employee_Name'!G:G="Bob","") I have changed...
  2. B

    Sumproduct - Sumifs - Choose

    Hi there, I have two tables for labor rates by function and by year. One table for GBP currency, and one for USD currency. I then have a table that contains labor hour requirement by contract (many rows). Each contract is either native to GBP or USD. I'm trying to use the following formula to...
  3. T

    Sumifs using unique and filter functions

    Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...
  4. jase71ds

    CHOOSE function: First Argument is "index_num" - Can I reference an Array??

    Hi kind folks. As I've been learning the CHOOSE function, I've fallen in love. It's such a humble, but powerful, little function. The arguments (according to intelli-sense) are: CHOOSE(index_num, value1, [value2], [value3], [value4],...) The index_num argument can be a cell reference, but...
  5. U

    Swap values in the rows and column based on given value that are extracted from a parent child data sheet

    I have a Excel table in the form below that was extracted from a separate sheet: Level1 Level1-Level2 Level2 Level2-Level3 Level3 Level3-Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild...
  6. U

    Want to fill and swap values in the cells and column

    I have a excel table in the form below: Level1 Level1- Level2 Level2 Level2- Level3 Level3 Level3- Level4 Level4 a b c d f i j b a d e g g k b e c h d i The Level1 is parent records, Level2 is child records, Level3 is grandchild records and so on... Level1-Level2 is...
  7. S

    Multiple Cell Check without VBA

    Hi, I have an hard time being able to figure out a solution to my issue and would like to see if anyone can help or has ideas of how this challenge can be resolved. I am trying to find a formula that is able to tell me if a cell has changed from a number to a text (horizontally) resulting in...
  8. M

    Do i need Vlookup or Indirect or something else?

    I have a simple workbook with two sheets. Sheet 1 contains: <tbody> NAME AGE HEIGHT WEIGHT JOHN 34 52 23 PETER 23 12 62 LUCY 45 23 86 DANIEL 23 42 34 </tbody> Sheet 2 contains a message: Choose a person I then has a dropdown/combo box (data validation list, the source being the list...
  9. J

    "Choose" function for the Best Running Time

    Hi, I am storing all of m running times on an excel sheet. I have the distance run in column A (lets say A1:100) and the time in column B (B1:100). In a separate table columns E and F have ranges of distances (0 - 10[in E1 and F1 resp.], 11 to 20 in row 2, 1 to 30 I row 3, etc). What I want is...
  10. A

    Data Validation

    Dear Excel Experts, In first row from Cell C1 to M1 there are name of persons and below 4 rows have specific numbers. I have set in column A all first row name by using data validation list criteria. I want a formula in column B. if a particular name select in cell A2 then at cell B2 shows all 4...
  11. S

    [VBA] Custom two-option user Popup

    Hi all, Hope you're having a good day. I want to create a popup for a user to choose between three options Select a file, Select a folder, Cancel I made a userform to handle this. If they choose to select the first option, I want to use Application.FileDialog(msoFileDialogFilePicker) to...
  12. D

    Responsive list / pivot - No VBA

    Hi Guys, Forgive me the thread title, but I had no idea how to call it. I'm having a table, where I have to choose Yes/No. If I choose Yes, I want this choice to be displayed in another table. It can be partially done with a pivot, but I need to press refresh each time I make any changes in my...
  13. S

    Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources. The sources are mainly Pivot Tables but is there a way to actually edit whatever is being shown in the Camera...
  14. S

    Help with CHOOSE function

    CHOOSE function has syntax CHOOSE(index_num, value1, [value2], ...) I have 100s of values (text values) to deliver to CHOOSE function. Instead of typing all those values every time, I want to keep those values as defined name. I tried to define a name and handed overt to CHOOSE, but it...
  15. A

    Code link optionbutton ,compobox with textbox and cells in sheet

    hi, expert i would help finding code connect the data sheet with optionbutton , compobox and textbox in userform for explanation i have data in sheet1 in columns c,d are two prices price the column b is the brand and userform 2 optionbuttons and compobox1, textbox1 here when i choose the...
  16. danhendo888

    Cannot filter by months in Pivot Table!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm I have a sheet of data. I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot table. But I want to be able to choose the months in the pivot table, but I'm unable to do so. What do...
  17. sharky12345

    Prompt user if file save is cancelled

    I have a routine which prompts the user to choose a folder to save an embedded Word document as PDF; FilePath = Application.GetSaveAsFilename(InitialFileName:=File121, FileFilter:="PDF Files (*.pdf), *.pdf", Title:="Select Folder to save") It works fine, except if the user clicks cancel in...
  18. danhendo888

    Help with dynamic (?) formula for adding values!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z Hi guys, I have monthly revenue data that I want to add (YTD figure) Need a formula whose output updates based on say if I choose YTD May. Then it should add months 1 to 5 for the year. How would you approach this solution?
  19. D

    macro from drop down list

    I have 4-6 marcos that i want to be able to choose from in a drop down list.
  20. K0st4din

    Select specific worksheets and save to a new workbook

    Hello friends, I searched a lot on the internet and found countless similar solutions, but not exactly what I was looking for. I ask for your assistance. I have a workbook with 38 worksheets. I made myself a UserForm1 in which I inserted 28 worksheets with their names. These names are with...

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
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 "".
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