Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to count the diferent articles of a column where the result its
between an interval (the criteria is defined in two cells). in my datasheet its possible that the same article has different results. example: Data ____________________ (articles) (result) Column A Column B aaa 7 bbb 7 aaa 15 aaa 6 aaa 8 criteria ____________________ Column C Column D 5 10 Analysing the result, i have 3 "aaa" and 1 "bbb". I want to konw a formula that the result result is 2 articles (artilce "aaa" + article "bbb"). thanks, gmfp |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to convert Value to words?Eg.Rs.1000/- to Repees One thousand | Excel Discussion (Misc queries) | |||
Conversion of Numercials to Figure | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |