tricky

I'm not sure if it's even possible, but I need help in the following: so far, I made a made to insert rows, by the value of D minus 1, each time column D is >1. The macro is working from bottom to top since its trickier for the macro to function if the last row keeps changing as its going top...

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...

Hi, I am sure there is an easy way to do this (I hope) but I am struggling. Please help :-) I have a large set of data, about 30 columns and about 40,000 rows. About 7 of the columns need updating regularly but it's cumbersome to navigate and tricky to reorganise as the data is appended to...

Can someone help me on below formula, used to populate unique values from a Range "NAME", present in DEPT "Science" MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0) Complete Formula: {=INDEX(NAME,MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0))} Note: This formula is used in...

Sorry the first post was messed up... I have used match function to compare cell A:A to cell E:E, if there's a match cell D displays either true or false. Where there is a match I want the name of that product from cell A to appear on another page. So A...

Here I'd like to find the way to get starting 3 letters of every country. paste these values into Column A ie. AUS for Australia IND for India Many thanks <tbody> <tbody> 001-01-Australia-02-06 12-2-Japan-65 236-01-India-45-01 1401-3-Singapore-458-1 456-01-France-456-2...

Hi team looking at getting the count of employees that have attrited, e.g. in cell A1... this can only be done if the agent (found in range C1:C42) were present for less than 15 days but more than 0 days.. i have used this formula but all i get is a value error. please help...

Hopefully someone can help, I am looking to help with creating a VBA function to essentially "rebase a number" The function would have 2 inputs, the hex number to rebase and the new base. Public Function HEX2ANY(input1 As Integer, input2 As Integer) End Function If I were to do...

I have a tricky question which i can't get my head round and was hoping for some assistance. i need to do a sumif on multiple criteria (so a sumproduct is needed but it is causing issues) I need it to sum on the following criteria 1. Cell B1 = something in column C 2. Cell D3 = something in...

I need a formula that will sum up to a blank cell. Is there such a forumla or macro that will do that?? Something along the lines of typing a formula into D30 which would mean the following IF (A30<100, sum(C30 upwards to next blank cell), 0). A macro may be required for this so any help...

Hi all, sorry if this was covered already but I couldn't find a thread that matches my problem. Basically I have two documents, they are both the same file basically, but one is an update on the other. The info inside is a list of values (usually text but sometimes is numbers - a string table...