ref

Hi, Need help again with another formula.. this one is kinda complicated.. I have SHEET A Below: Ref numbers in column A, 1 thru 75 numbers to be searched in columns B thru BT, every other row, <tbody> A B C D E F G H I J K L M N ALL THE WAY TO BT 1 1 45 34 55 50...

Hi, I have 2 worksheets, WS1 and WS2. In WS1 I have a table and in Column A is a reference number (unique). Currently 1 to 15. In WS2 I also have a table with multiple rows. In each row is a reference to a unique ref number in WS1. For example, Ref 1 may have multiple rows in WS2 that...

What Power query formula would i need to convert the Shop ID that appears in my Ref column into it's own column as per the second data sample? Ref Rep Date Amount 101 Melbourne JKL0345 PJ 1/07/2017 453.98 HLK0462 KL 1/07/2017 364.78 IDE876 PJ 1/07/2017...

So, I'm new to this forum and hoping you can help me with a formula... I think it's simple but explaining it might be hard. I have two tabs: tab 1: <tbody> URN Ref 2318 YOU008 2319 YOU009 </tbody> tab 2: <tbody> Ref sALES YOU008 £5 YOU008 £10 YOU009 £5 YOU009 £25 YOU009 £23...

I have a workbook with several tabs. In the front sheet (sheet 1) I want to add up the total of cell A5 from every tab. Every tab pulls data from the master sheet (Master sheet) using the below formula. =IF(ISBLANK('Master sheet'!AA5),"",'Master sheet'!AA5) This is causing the problem as...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am a basic Excel user for the windows 2000 version at work,<o:p></o:p> I need to create a column in A that will take info from another field & add a number to it (for instance see below) but automatically...

Hi, I am using the indirect funciton combined with the match funciton to look up cells from external workbooks. All the workbooks are open however I am faced with a sheet full of #ref cells :mad:. Yesterday the same thing happened, although the sheet decided to work an hour after my...

I created a macro that imports production results from multiple staff folders. Before I had the macro I was manually coping and pasting their results into staff tabs that was auto filling a PivotTable. When I clear the data that was imported the links to the other tabs are lost, they give me the...