def

Hi, I'm trying to set up a 1 column table (Table B) that looks up the unique values from another table (Table A). Table A <tbody> Company Contract Apple 123 Google 456 Samsung 789 Apple ABC Samsung DEF Samsung DEF </tbody> Table B <tbody> Select Company Samsung 789 DEF...

Each week a file is posted to the same folder in sharepoint. The file name is the same except for the date For example: ABC DEF GHK - 20180217 - Sales.xlsb ABC DEF GHK - 20180210 - Sales.xlsb ABC DEF GHK - 20180203 - Sales.xlsb I just want to open the most recent version of the file when I run...

Hello, I have data in cell ref A1 which look something like this. .. Abc def 47 so a formula in cell B1 should output value = Abc def and similarly in cell C1 output = 47 more examples:- A1 = Abc B1 = Abc C1 = A1 = Abc 5 0 1 B1 = Abc C1 = 501 A1 = 50 0 B1 = C1 = 500 A1 = Abc 50 40...

How can I create multiple rows when there are multiple data points for the same attribute? Thanks!!! For example, if there are 3 investors in company ABC, then there will be 3 rows ------------------------------------------------------------------------- <colgroup><col><col...

Hello, I would really appreciate some help. I have a spreadsheet with 19 columns. In column A there is a generic code In Column K there is another generic code In column D there is a quantity A D K (qty) ABC 1 123 XYZ 2 123 DEF...

I have a worksheet similar to below. in the two columns under "values >1" I am calculating the number of times a value in my data is >1 for that particular header. i have a solution for this which is extremely taxing as I have 6500+ rows of data across 16 columns. To calculate the ABC and DEF...

Hi all, I know this goes against what pivot tables are meant to do, but for display purposes this is what I am trying to achieve: Data: ...

I currently have a worksheet which consists of multiple sheets. On sheet "Imp. and Def. Rank Template" I enter in information which is all based on the entry number (Cell "B2") and then have a properly functioning macro which will do 1 of 3 actions depending on IF statements: 1) If the entry...

Hello, I am new to macros and am having a bit of trouble attempting to setup my code thus far. I am trying to do the following: I have a spreadsheet in Excel with multiple sheets. On sheet "Imp. and Def. Rank Template" I have essentially a form setup where I fill in various cells of...

Question... I am trying to write a macro that takes the Value in B1, finds B1 in row 5 and pulls in the coresponding data in E1:F3. I would just put in an index match match but the data prior to the current week has to be able to stay without getting deleted. Any help is greatly appreciated...

Hi I need help with a similar thing to what jufglanville has posted. Basically I am trying to find out what subjects students are studying in a year group at the moment my spreadsheet looks like this abc ar ms gp gg def en sc ma hi And...

I have a spreadsheet with data in columns A:L. All of the data is the same expect for columns H & L. Is there a macro (vlookup and sumproduct take to long to calc) I can use that would basically take the 1st entry and and copy it to a new sheet with the value in column L the sum of all the...