| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
seeking of array
Hi Tomek S,
Mass = Length*Width*Thickness*Density, so you need to know the Density. Ken Johnson |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seeking of array
I don't want to calculate mass!! I wanto to find in the array value of mass
when I know values of Width, Length and thickness. I want to seek array to find this value!! Best Redards Tom |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seeking of array
Sorry about that!
If required length is in A1, required Width in B1, required Thickness is in C1 then... =SUMPRODUCT((A2:A6=A1)*(B2:B6=B1)*(C2:C6=C1)*D2:D6 ) will return the Mass Just change the array addresses to include all of you data. Ken Johnson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seeking of array
Hi Tom,
Maybe you meant Best Retards, which is what I felt like after my first reply:-) Ken Johnson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
seeking of array
Uzytkownik "Ken Johnson" napisal w wiadomosci oups.com... Hi Tom, Maybe you meant Best Retards, which is what I felt like after my first reply:-) Ken Johnson No! I meant Best Regards :). My mistake but I admit Your post wasn't funny ( at first moment). Best regard :) Tom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transpose words and numbers into array of different proportions | Excel Discussion (Misc queries) | |||
| Return Array with Array | Excel Worksheet Functions | |||
| Pass an array to Rank | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Hybrid Mode
