Hi Mathan,
I used column A to determine the number of rows that should be
included in the
pivottable range. And I used Row 1 to determine the number of columns.
I assume that the headers are all nicely valid--no duplicates and no
blanks,
right. And that you want Sum for each of those other fields
Hi Selva,
Step 1: Separte the numbers using Text to column using "Space" as
delimiter
Step 2: Select Edit\Go to\ and click special and select constants and
unselct the check box Numbers below the formulas options
Step 3: Delete the selected cells
You have got only the numbers, but in different
Hi Amods,
Please find the user defined funtions for extracting the numbers and
text.
Function ExtractNumber(rCell As Range, _
Optional Take_decimal As Boolean, Optional Take_negative As
Boolean) As Double
Dim iCount As Integer, i As Integer, iLoop As Integer
Dim sText As String, strNeg As
Hi Abhishek,
I hope this will help you.
=IF(A2="A+",IF(B2="Cartons",IF(C2>=1,"Yes","No"),IF(B2="Bales",IF
(C2>=1.5,"Yes","No"),IF(B2="Pallets",IF(C2>=2,"Yes","No"),IF
(B2="Others",IF(C2>=3,"Yes","No"),)
This formula assumes that Column A, B and C contains Category, Type of
Cargo and Time tak
