Forum

Please supply a workbook with sample data and examples of your expected outcomes, and cover all scenarios. Thanks Phil

No worries - see attached. P

Hi Candid, try this attachment. The values for the bands (1M, 20M etc) are hardcoded into the formulae. So you should replace these with cell r...

Hi Candid, This is why it's always best to include a workbook and several examples of the desired outcomes. So to make sure we are clear, do you...

Hi Candid You should read about nested IF statements =IF(A2<=1000000,0.055,IF(A2<=20000000,0.03,IF(A2<=30000000,0.025,0.01))) Work...

Hi Andi, Not sure how you can change a cell, but at the same time not change the cell. Why do you want to do this? If you can explain your inten...

Your data validation formula could be =EXACT(B2,VLOOKUP(B2,E2:E6,1)) with the cell you are typing into being B2 and the permitted list of inputs...

PBI File attached

Chen, There's no attachment. Phil

Try =HYPERLINK("F:Study Material"&C3&"2017" & A3 & ".docx",A3)

Hi Maurizio, Your code is looking for elements with the HTML class name "sunny" but I don't see anything on the page that has that class name. The ...

Please supply the workbook so we don't have to key in the data and recreate everything. If I enter your COUNTIFS formula into the Units column I ge...

Hi Luke, I have no problem with that string either. You haven't supplied the XLSM that generates the codes though so it's impossible to check wh...

Well, if you don't send the email using VBA then you can't test if it has been sent. If you just display it, and then rely on you clicking on SEND ...

Hi Stefi, If there's some relationship or way to identify what you want to sum then you can do this. But looking at the examples in your workboo...