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
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 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 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
