| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
set formula to display a data from a 5 columns table
=OFFSET(A1,ROUNDDOWN((A9/10)-0.1,0),(ROUNDUP(A8/1000,0)+1))
-- Gary''s Student - gsnu200793 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display data values in columns on bar chart | Excel Discussion (Misc queries) | |||
| Compare several columns of data and display unique ones | Excel Discussion (Misc queries) | |||
| Display columns side by Side in the Data Area of a Pivot table | Excel Discussion (Misc queries) | |||
| Can I suppress display of duplicate data in columns? | Excel Discussion (Misc queries) | |||
| Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Threaded Mode
