| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a "variable array?" to report data
I am not sure if a variable array is he right terminology but here is what I
want. I am exporting data from a Sharepoint list. This data can change everyday so I need the spreadsheet to reflect that via auto updating. This is not a problem, works great, the issue is that the data comes in formated incorrectly for what I need to report on. The data come in as a list. Thing Milestone Hours AAAA 1 2 BBBB 1 3 CCCC 2 2 DDDD 2 4 EEEE 1 1 FFFF 3 5 GGGG 1 3 HHHH 3 1 IIII 3 3 JJJJ 3 3 27 I need to present it organized by milestone. Thing Milestone Hours AAAA 1 2 BBBB 1 3 EEEE 1 1 GGGG 1 3 9 CCCC 2 2 DDDD 2 4 6 FFFF 3 5 HHHH 3 1 IIII 3 3 JJJJ 3 3 12 is there a way to create an array on a second work sheet that would only contain data that matches the Milestone critera? Thanks Jeff -- Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
| How Do I Get Out Of "DATA" ~ "CREATE LIST"? | Excel Discussion (Misc queries) | |||
| create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions | |||
| Adding "fixed" data to variable length data | Excel Worksheet Functions | |||
Threaded Mode
