thing

Strange title I know, soz... k so here's the thing. Say you had a list a b c d e f Now when it gets to `f` I want it to go to a1 b1 and so on so I made a lil list on a adjacent column 1 2 3 4 I'm saying to excel:- ok when you complete the first list, then CONCAT `A` & (cell ref for #1 )...

I am looking for help developing a formula that will subtract two columns if a third column is yes. It must be an IF formula of some sort but I am struggling to figure it out. Here is what I want to do. If column K is yes (they did the thing), then subtract the date in column L from the...

Hi All Please could help be provided with the following. I am trying search for a value in the Name Column - in this instance ABCD and at each occurrence return the entire row associated with ABCD Sample data <colgroup><col><col span="6"></colgroup><tbody> Name Thing 1 Thing 2 Thing 3...

Hi All, When I try and click and drag to select cells to copy (for example) if I have to drag to make the page scroll down Excel keeps entering this weird formula and it is really difficult to get rid of - does anyone know why it is happening (or what stupid thing I am doing???) Pic of example...

Hello all, Trying to keep a =cell to always refer to that cell number (not the contents but the actual cell itself) even if i drag/move the contents of referenced cell. Absolute reference ($a$1 doesnt work) For clarity; I want Sheet2 A2 to ALWAYS reference to sheet1 A5.Even if I drag the...

I've tried all the usual solutions. Checking if automation is on. cells are not set to text. Check for Circular References not an issue The strange thing is if I restart the computer it will sometimes work. Corrupt excel or something else?

Basically I have a column of employee's names and then a row of other criteria. On a second sheet, I have the column of employee's names again, plus a column which would contain the same criteria, and a third column with a number. If the name matches and then the two other criteria match, I...

When group level 2s in level 1 thing in video happens -(When last row of level 1 is included in a level 2 hierchy. Grouped data should be in level 2 but its beyond level 3 as in the video in attachment) When all level 2 headers are selected and grouped for level 1 thing in image happens-

I have a mental block when it comes to VBA and am on a timeframe to get myspreadsheet working properly. When a date is entered into Column H, I need the row to be lined through and then moved to the bottom of the list. I think this should be a simple thing to do but am lost. To boot, I can't...

Hello guys,I need a bit of help! ok, i've been trying to do this without macros, and i'm going nuts.I have 2 workbooks, one with codes that need to be added to the current one I have here. The thing is, I need to check and copy the new codes to our current workbook, but i've been doing it...

Hi, I need to count a range of cells that are non blank and does not contain the text "COMPUTER". I can get it to do one thing but not both using =COUNTIF(D11:D43,"<>*COMPUTER*") Thanks,

Hi all, I have created a form on Excel that once filled in I would like a log with some of the cell values to be populated on a separate worksheet. Does anybody know where I would start with such a thing? I am happy to share the workbook if required... Many thanks,

Dear Friends If cell A1 rat A2 A3 cat A4 bat Now I want to count how many cells contain words. but the thing is that cell A2 is not blank but contains a single space. Please suggest a formula. Regards Pigeon INDIA

Sir, Good evening am trying to write a macro for saveas a portion of excel worksheet in pdf format, but am unable to do the same since sintax errors coming, can any one can help me in this regard one more thing is the file created should be name as content in cell "A1" of "sheet1" Thanks

Evening all! Im trying to create a new spread sheet and well, iv come accross my brain block.. you can see in the spreadsheet attatched. http://s000.tinyupload.com/?file_id=84408271285290770767 Im trying to write a formula that will populate the 'F' (forcast) Column with the Weekly Spend over...

In rows at the top (B1 - G1) I have six team names (text). In the columns below B1 - G1 I have their scores. The scores are cumulative so a summed total occurs in B39 to G39. I want to print on a separate sheet the current highest score in the form of a leaderboard. Here is an example...

When my company upgrades MS Office, I lose all my macros and QA toolbar icons in Excel. Is there a way to preserve them before an upgrade? Example, when we went from 2007 to 2010, my macros and QA toolbars reverted to default. Same thing when we went from 2010 to 2013

I have 2 sheets, Sheet1 and Sheet2 On Sheet2 I have an equation that shows a value from Sheet1 with the following equation: =Sheet1!A4 What I want to do is be able to change what column this formula pulls by changing cell B4 on Sheet2 I tried: =Sheet1! & INDIRECT(B4) & 4 (where B4 contained...

To any reading this, I'm looking for a way to dynamically copy and paste values from two separate ranges into another column. This is because we sell items either by a single color or as a dual color. For example, a customer could order all of their stuff (Wall and island) in color 1 or color...

So I've got a bunch of cells going down column A with strings like the below examples and I would like to be able to use each number in an IF function. Is there a way to store each number in A1 as a variable that I can use in an IF function and then once all the numbers are stored and used, move...