ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wkst2 w/all ABSdata computed from wkst1-can't "Find" data pt in#2 (https://www.excelbanter.com/excel-discussion-misc-queries/105640-wkst2-w-all-absdata-computed-wkst1-cant-find-data-pt-2-a.html)

wirecup

Wkst2 w/all ABSdata computed from wkst1-can't "Find" data pt in#2
 
A second worksheet is all absolute values computed from another referenced
worksheet. I was able to post the maximum and median values for each column
of data in the second worksheet. However I can not search the data columns
(using FIND and a selected range of data in a column) in the second worksheet
to find where the maximum value occurred. This FIND procedure works in the
original data worksheet (#1) but not in the other.


All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com