# Search results

1. ### How to make drop down list except the selected name in the particular cell

We can use formulas to build a new list that doesn't include selected items. I also built your dynamic validation as wlel.
2. ### Copy all visible cells excluding blank and zeros

Since you've already got a filter applied in a way (you're checking for visible cell), then I'd just add another criteria to the filter to hide the cells with 0 and blank. Then it's a simpler copy & paste.
3. ### macros for vlookup in dynamic range with two worksheets

Hi trividha, You'll get more responses if you start a new thread rather than tacking onto an older one (especially one from 2015).
4. ### How to create a list from a list?

It acts as a counter. The COLUMNS function returns a number indicating how many columns are in the given range. So, at first, this evaluates to 1. When you copy one cell to the right, the range becomes \$A1:B1, which then evaluates to 2, then 3, etc. This is so that the SMALL function is being...
5. ### How to create a list from a list?

Put this array formula in AC6 =IFERROR(INDEX(4:4,SMALL(IF(COUNTIF(\$C\$7:\$Q\$7,\$C\$4:\$AA\$4)=0,COLUMN(\$C\$4:\$AA\$4)),COLUMNS(\$A\$1:A\$1))),"") NOTE: Confirm as an array using Ctrl+Shift+Enter, not just Enter. Copy cell to the right as desired.

7. ### Need help to export used ranges of sheets to pdf

@zrs As Alan has discovered, please remember in the future to post links to cross posts, as it saves everyone some time.
8. ### Using dynamic reference with structured references in formula

If 'Alfie' was in B1, you can INDEX the column you need via something like =INDEX(emp_table, , MATCH(\$B\$1, emp_table[#Headers], 0)) Plugging that into your original formula =sumifs(INDEX(emp_table, , MATCH(\$B\$1, emp_table[#Headers], 0)),emp_table[[Weeknum]:[Weeknum]],\$A2)
9. ### Hello, How I can extract unique data from table based on a criteria from another sheet and put the result on the same sheet where the criteria

I'd suggest running an Adv Filter. It's designed so that you have a data table, criteria range, and output range. You can also sepcify unique records only. It's easy enough to do manually, but if you want to use VB: https://www.contextures.com/exceladvancedfiltervba.html

Rollover chart with two series
11. ### Enter cell value if between start and end date

Formula in D3: =IF(MEDIAN(D\$8,\$A3,\$B3)=D\$8,\$C3,"No Estimate")
12. ### Drill down by click or double click on a specific column of the chart

As the only way to do this would be via VBA, I'll move the thread.
13. ### Indirect formula help

Your setup is confusing. It looks like you're trying to use the labels in col A to figure out which sheet to grab, but the sheets have the non-descriptivate labels of "Data entry (7)" rather than "Data entry QBQ". IMO, I'd change the workbook design. First, get all the raw data on a single...
14. ### Hi @kabanda . You'll be more likely to find assistance by posting a question in the regular...

Hi @kabanda . You'll be more likely to find assistance by posting a question in the regular forum, rather than here, which is just my personal profile page. https://chandoo.org/forum/forums/ask-an-excel-question/post-thread

16. ### Status Color

Hi @SharadSalvi Welcome to our forum. However, you'll get more help if you start your own thread, rather than tacking on to someone else's previously solved thread.
17. ### HELP REQUIRED FOR ANALYZING DATA

Welcome to the forum! Your attached file is hard to understand as it only has one sheet with info. Is that in the desired output, or how the input looks? It currently looks like the layout of a PivotTable. Please clarify what you have vs. what you want.
18. ### Need help to avoid popup msgbox while sending an outlook email thru excel

Note that that message is specifically there to avoid people using malicious code to send email w/o users knowing. Bypassing it could be considered annoying to some users. That said, you could get around it by either a) Just having the email be Show, rather than Send, and let user manually...
19. ### Query on Advanced filter

Missing commas between the arguments of AdvancedFilter. Also, line breaks need a " _" after them to show the code continues. Finally, when listing out argument names, you use ":=", not just "=". Cleaned code: Sub FilterDataraja() Sheets("Sheet1").Range("A1:L15").AdvancedFilter _...
20. ### I want to make custom looking chart through Pivot & Slicer

As Khalid alluded to, be aware of time differences. For my time zone, you posted your question after business hours on a Friday, and I don't check back in until Monday. Here's a start to your file. Chart created as pictured, and slicers made.