vol

Hi, I wonder if someone can help. I need to write either a long IF formula or maybe VBA – I’m just not sure! I have a spreadsheet with a number of columns and rows and I need to pick up data from a separate sheet in the workbook depending on the information in specific cells. So in row I...

Morning everyone, i will appreciate your help to elaborate a Subroutine or UDF to substitute/delete all the words from cell B1 into cell A1, showing the result in cell C1, example: B1 may have more than one word, all separated by comma + space ", " <tbody> <tbody> A1 B1 C1 ALTEA...

Hello Everyone, I'm afraid i am not able to put the picture of the file for better understanding. Though, i tried and failed. I will try my best to explain. In the below grid-1, in front of the date (1-Feb), i want to insert a formula that uses the grid2 (mentioned even below). The formula...

Hello everybody, I have a multiple choice testing bank with a random question generator. I am working on getting the answers to populate on the master test version but I think the amount of characters is causing some #VALUE errors. =VLOOKUP(B13,'3P051 VOL 1 BANK'!B:C,2,FALSE) B13 = Cell to...

I'm getting seriously mad... ;) I have this data table: <colgroup><col><col span="2"><col><col><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody> Regular Unassigned APC low GIN Matr Area Country Customer Vol APC APC Customer Customer APC Customer 123456...