Hi Meyanui What the formula SUMIFS($D$4:$D$29,$C$4:$C$29,G6) does is to sum the range D4:D29 when the range C4:C29 meets the criteria in cell G6 et...
Since there is no hard and fast rule it is more difficult. Give this macro a try. You will need to copy the module to your file and create a link t...
Hi Meyanui Give this a try. Sunny
Give this a try. Sunny
Hi Dritan I believe the length of your formula is too long (286 characters including the = sign). As far as I know, for Data Validation the maxi...
How did you determine the values? What calculation did you use?
Hi Mey You can use Advanced Filter to do that. No need VBA. 1) Output sheet must have all the required headers 2) Go to sheet 2 and select an...
Hi You did not give enough info on what you wanted. 1) What basis is used to distribute the values. 2) Which row/column need to be filled. ...
Hi Paul Glad we could help Cheers Sunny
Hi Revathi No idea what you meant by "simplest" formula. For me all formulas are complicated. See if the attachment helps. Sunny
Hi Paul One way is to use a COUNTIF to check each column from B:G to determine if the number is found in columns J:S. If it is found, then it is...
Thanks Mynda I think Chris have "discovered" a pretty cool trick and it is very impressive (thanks Chris) Somehow by deleting the entire row 46...
I was able to replicate the error. Example: 1) Cell CS6 enter a value eg 999 2) Copy CS6 and paste onto CP3. 3) CP3 value will become >...
Hi Sotiris Glad it is working for you. To add on to your codes, just move the line Application.ScreenUpdating = True To the bottom of yo...
Give this a try. Good luck Sunny