Trying To Match Entries In Two Different Spreadsheets - Please help Hi,

I work as an accountant in my company. One of the tasks I have is to match our VAT data that is sent from our tax authorities every month with our own VAT data. Attached are two spreadsheets. One of them has been sent by the tax authority. There is a column E which has the invoice numbers...
https://www.excelforum.com/sho....wthread.php?t=143155

Randomly mix a team of certain players but fix certain ones Hi, I am trying to create an excel sheet where I can add say 16 golfers ( 4 players in 4 teams) on a list and then choose to fix say 3 of these players in a certain position on the table but then randomly mix the other 13 players.

I have enclosed a spreadsheet with and example and have tried...
https://www.excelforum.com/sho....wthread.php?t=143155

Vlookup of two criteria I am trying to create formula as under :-

If data in column G or I matches with data in column X or Y then mark "MATCH" in column H
sample output file is attached.
Kindly help.
https://www.excelforum.com/sho....wthread.php?t=143155

[SOLVED] hour calculation Hello Everyone,

When I enter 11 (November) in cell A1, I want to calculate how many hours (720 hours) in the relevant month in cell B1.
I would like your help on this issue.

Best regards,
https://www.excelforum.com/sho....wthread.php?t=143156

Add items to listbox based on multiple combobox and textbox selection Respected Members ;
I wish to Add Data in My ListBox Named "CTLB" based on multiple criterias
The criterias being me.rec2 ,me.rec5 , rec6 rec7 rec8 rec9 rec 11 corresponding to ColumB , E, F, G ,H, I, K , RESPECTIVELY.
values in crieria controls are already populated with unique values the code...
https://www.excelforum.com/sho....wthread.php?t=143156