Search results

Here is the cell formula: =SUMPRODUCT(ISNUMBER(FIND($A3&",",'Dispo'!$O$1:$O$5000&","))*(B$2='Dispo'!$I$1:$I$5000)*(B$1='Dispo'!$G$1:$G$5000)) Thanx very much for your help. David

Thanx very much... i used a version of sumproduct and it is working... one thing... sumproduct appears to be a beast with resources... tends to be slow... any suggestions on improving speed?

How would I do this if i wanted a sumif, based on the value in another column?

Excellent Shrivallabha!!! Thanx very much. it appears to be working!! Best Regards, David

I have a column containing several values, for example: B1, H, G B2 G4 D, D1 N,B2, L, L3, G1 O1 C G3 O2, Q2 L6 I1, I2, L4, Q2 How do i find the count for each unique value? I have used: =SUM(--NOT(ISERROR(FIND(A3,'SCR Dispo'!N:N)))) as an array (ctrl+Shift+Enter), but it counts...

Thanx very much. lets say list one is a grocery list.. cheeze, meat, juice, vegies... when i select meat, list 2 would be a selection of available meats... if i choose juice, a list of available juices would be available.... now if i choose juice, then one of the juices is apple, then list 3...

list 1: 1,2,3,4,5 If 1 selected then list 2 becomes: 1a, 1b, 1c, 1d, if 2 selected then list 2 becomes: 2e, 2f, 2g, 2h, 2i etc... the drop down box cited above is in the sheet itself. I am looking for a "Click Here" button to open a form that will have the control box selections. the 2nd...

I am trying to creat a data entry form where users make a selection from list A, then based on this entry, list B provides a list of options, then List C is provided on the previous entries. I have tried with data validation, however, I want a data input form to record the entries and other...

i have found a solution, which appears to work (so far) Ctrl+Shift+F9. it seems that there was break somewhere hidden, and from another form Smurf On Spreadsheets, it was suggested... the strange thing was the error occured in various workbooks, although the coding was the same. I figured it...

Narayan, Thanx very much for the help. Unfortunately, i cannot open this link due to security settings. would you have another methode? Best Regards, David

error that comes up is: Code exectuion has been interrupted When i hit debug, .Cells(lRow, 3).Value = Me.ComboBox1.Value is highlighted in yellow (this time) Thanx very much for your assistance!!

The tab "Comments" is confirmed correct, no spaces... When the error occurs, if i say continue, it continues to paste the data. However, each time the data is saved, the error appears at a different step... sometimes Me.txtDate.Value, sometime on Me.ComboBox1.Value... making tracking the...

I have an excel 2007 work book that requires input from the user in the form of a table. I have created the data input form, and it maps to a tab in the work book, however, resently it has started stopping when updating the data. The associated code is provided below: Private Sub...