Search results

I was going thru your file and got one more question in mind, what if the related ID is also not have any cluster.... like related ID = 4. Regards, Prasad DN

Hi, can you help me understand this piece of your requirement.. "Should there be more than one related item, then I should have one per related item in the count ifs or sumproduct." Also, what about those records where there is no cluster nor related ID? Regards, Prasad DN

Hi Khurrum, You have done very good job with spreadsheet. I used your own formula to get you your results. :) Type the below formula in Row C35: =IF(C33>=(LARGE($C$33:$R$33,5)),C33,"") and drag upto whichever column you need. ;) Regards, Prasad DN

Hi Haz, very neat technique... the only limitation is you cannot send cell reference as parameter/arguments. Ex Result is hard coded to F6, and if I need to do similar action for F6 to F10 etc then i Need to define Result1, Result2 etc... Do you think there is any improvement for this...

Hi, Your requirements are not clear. Are you saying in report sheet D4 you enter the Company name like A1, and then you expect the data from UPdate client sheet to come in report sheet? pls clarify regards, Prasad DN

Hi, Try this VBA code: Sub RemoveDataAfterGrp() Dim iCol, iRow As Integer iCol = 1 iRow = 3 Do While Sheet1.Cells(iRow, iCol) <> "" If VBA.InStr(1, Sheet1.Cells(iRow, iCol).Value, "Group", vbTextCompare) > 0 Then Do Sheet1.Cells(iRow, iCol).Value = "" iRow = iRow + 1 Loop Until...

Hi, You almost got it! Try this code after you do copy paste: Dst.Cells(LastRow2, "A").EntireColumn.AutoFit Regards, Prasad DN

Hi Deepa9, In reference to your above quote, if you see the formula it creates when you use getpivotdata, you can see if it referring to Jan (like absolute reference), you need to edit it to Feb manually, or you instead simply give the cell address like relative reference. Again, as Narayan...

Hi, I believe you can try GetPivotdata() formula. whenever you do refresh PT, it will automatically update your data sheet. In case you need to retain the previous PT's numbers, once you get the data using formula mentioned above, copy and paste as values, so that whenever you do refresh of...