| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find the numbers used in a range
use subtotals
-- Thanks Suleman Peerzade "MIK" wrote: I have a range D1:Q25 that can have differnet numbers and the numbers can repeat. In column A, I want to list the each number used in the range. Column B is to show the number of times each number is used in the range. In other words, I want to make a summary of numbers used in the range and show how many times each number is used in the range. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find the numbers that are used in a range | Excel Discussion (Misc queries) | |||
| How to find a range of numbers? | Excel Worksheet Functions | |||
| Find Median of Positive numbers only in Range | Excel Worksheet Functions | |||
| Using COUNTIF to find numbers within a range greater than the mean | Excel Worksheet Functions | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
![Suleman Peerzade[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
