enow.com Web Search

Search results

1. Results from the WOW.Com Content Network

2. UNIQUE and FILTER with INDIRECT function - Microsoft Community

   answers.microsoft.com/en-us/msoffice/forum/all/unique-and-filter-with-indirect...

   I'm having issues with using indirect with unique and filter inside. Goals is to form a table form few different files. There are list of numbers in A6:A+ range, but footer contains additional information which is not needed, so I made a function with filter: ```

3. can I use an indirect type formula within a chart data range?

   answers.microsoft.com/en-us/msoffice/forum/all/can-i-use-an-indirect-type...

   I have a spreadsheet with several thousand rows of data that is gathered over the coarse of a test, I only want to use a few hundred consecutive rows within a single column for averaging. I am using the indirect formula "=AVERAGE(INDIRECT(AB7):INDIRECT(AB8))" to average the values starting at AB7 ending at AB8.

4. Indirect Function #ref error - Microsoft Community

   answers.microsoft.com/en-us/msoffice/forum/all/indirect-function-ref-error/c3...

   That's how INDIRECT works - the argument is a reference to another cell, not just a number. In your case, you are telling Excel to put the value of cell "5" into A2, which does not make sense. You can put something like "A5" in cell A1 and then cell A2 would have whatever value is in cell A5.

5. Proper use INDIRECT in XLOOKUP function - Microsoft Community

   answers.microsoft.com/en-us/msoffice/forum/all/proper-use-indirect-in-xlookup...

   Hello! I'm having difficulties with using indirect inside xlookup function to get data from separate workbooks.

6. How to resolve the #VALUE! error when using INDIRECT to generate...

   answers.microsoft.com/en-us/msoffice/forum/all/how-to-resolve-the-value-error...

   The INDIRECT function can find 30 in cell B10 in both (2) and (5) above, however once the curly brackets are included in the INDIRECT function (5) or the values result in an array from the INDIRECT function, the resulting value(s) cannot be combined with any operator to obtain a numeric or boolean result.

7. Dynamic Filter Function Using Indirect - Microsoft Community

   answers.microsoft.com/en-us/msoffice/forum/all/dynamic-filter-function-using...

   Excel Top Contributors: HansV MVP - Andreas Killer - Ashish Mathur - Jim_ Gordon - Jeovany CV Choose where you want to search below Search Search the Community

8. How to INDIRECT with multiple range or selection that are not ...

   answers.microsoft.com/en-us/msoffice/forum/all/how-to-indirect-with-multiple...

   Excel 365 Indirect with Curly Braces around calculated output - Microsoft Community. Excel 365 Indirect with Curly Braces around calculated output. Goal: Indirect with non-contiguous ranges. Problem: Indirect with curly braces failed to work with calculated output which is delimited by curly braces.

9. Excel Indirect Formula - Microsoft Community

   answers.microsoft.com/en-us/msoffice/forum/all/excel-indirect-formula/ce964ae2...

   Excel does not have the power to reach into a quoted literal string and change what you typed. In fact, that is probably why you are using INDIRECT in the first place. When transferring a workbook from an EN-US system to a PT-PT system, it can change INDIRECT to INDIRECTO and FALSE to FALSO.

10. INDIRECT function not working - Microsoft Community

    answers.microsoft.com/en-us/msoffice/forum/all/indirect-function-not-working/7...

    I've tried working out the examples given on several sites regarding the use of INDIRECT for dependent drop down lists. I've tried this simple example (just the first part of the Produce and the

11. indirect function returns zero - Microsoft Community

    answers.microsoft.com/en-us/msoffice/forum/all/indirect-function-returns-zero/...

    =INDIRECT(A1&B1) is equivalent to =H25. This formula will return the value of cell H25; if this cell is empty, the formula will return 0. If you want to return the text H25, simply use =A1&B1