Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data connectivity across two seperate .xls files, interesting
Hi,
I have an interesting problem here. There are 2 spreadhseets (.xls files). The first spreadsheet has a columns which has either a Yes, No or NA in it. What the second spreadsheet does is it counts the number of Yes and No in that column of first sprsheet and calculates the % of Yes in it, and displays it in a cell. For example: B1 to B15, B18-B20. Out of these 18 concerned cells in first spreadsheet, 9 are y rest are no and there are no NAs say. Then say cell B1 in second spreadshhet displays 50%. So, the real deal is to collect data from another spreadsheet. Thanks for any help. -Sash. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Data from Seperate Files | Excel Worksheet Functions | |||
Selecting particular rows containing interesting data | Excel Worksheet Functions | |||
Matching data from seperate excel files | Excel Worksheet Functions | |||
How do I seperate data from a pivot into seperate worksheets? | Excel Discussion (Misc queries) | |||
how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) |