moment

Hello, I have a column that is conditionaly formatted. Cells change there fill colour depending upon the value. My cells change to red if the value <-0.1. Then green appears when the value>0.1 I have used rules type "cells that contain". but at the moment empty cells fill green. How can this be...

Hi Im very new on formulas / V LOOK UP'S and worked out whats below so far and it compares data in column J against data in column B and then put a "0" in to identify missing. =IF(IFERROR(VLOOKUP(J1,$B$1:$B$9999,1,FALSE),"missing")="missing", 1, 0) What im trying to do is do the same but...

Hello, looking for some help. I have a raw data tab which contains a large data set which can be grouped into 5 categories based on the attribute in column 'BB'. I have 5 tabs which I would like to look up the value in column BB and if it is a match then pull into the tab. Preferably I would...

Dear Sir and Madam, Need your suggestion on how to shorten this formula ? The data range is from B11 to B21, at the moment I had to manually add in one by one...

Hi All, I am trying to write VBA code for a CommandButton. I want the button to print in pdf a Dashboard from a tab in my worksheet called "Dashboard". It has 21 pages at the moment but I want to print it as one document and different pages need different scaling/margin settings. Is it...

Hi all, I am looking for a point in the right direction with regards to speeding up the process of filtering, copying, and pasting some raw data that I have. I have a table with all my raw data (based on observations from a tennis match), and at the moment I want to, for example, copy all the...

I have been to the following places, the following number of times. A 4 B 3 C 2 D 2 E 2 F 2 G 2 H 1 I 1 J 1 I want to find a formula that tells me that i’ve been to x places, x amount of times. So at the moment x=2. If I go to C again, which makes C=3, then x=3. I have made a COUNTIF formula...

I need help writing an IF statement and I'm sure it should be pretty easy, I just cant seem to make sense of it at the moment. Essentially it needs to say if any cell F2 - O2 = N then make cell P2 N if not make P2 Y.

I have the following code and I want it to copy and paste values and format like cell size etc. Sheets("home").Range("A1:E42").copy Destination:=Sheets(MonthYear).Range("A1") What do I need to add to it as it only copies the values at the moment?

Quite a basic query I think ... If the data in column F, finds a matching cell in column A of Sheet 1, write a "yes", if not write a "no" . This is what I have at the moment: =IF(VLOOKUP(F10,Sheet1!A:A,1,FALSE)=F10,"yes","no") It returns "yes" for a match, but returns "n/a" if there's no...

Is there a formula/macro that will allow me to remove all carriage returns within a cell? I can't seem to remove them and I've tried a number of things to remove them. Can someone please help if they have a moment? Steve

hi is there some code that will all to attach multi attachments in one go (normally would select items & copy ) for outlook. At the moment the VB I have/use only allows 1 at a time to be attached! MTIA & KR Trevor3007

Hy, I want to hide all the multipages on a given part of the macro, so i can show later only the needed tab later. I work with 8 tab currently but i never need to show them all on the same moment. This is my code at this moment: For i = 0 To 7 MultiPage1.Pages(i).Visible = False Next i...

For my excel formula for (capital) profits I need the values in some of the cells. However I only want the values of these cells at the moment when some capital is sold. When later buying back, these values will influence the profit, so is it possible in excel to only use the values in the cells...

Hello, I’m trying to use the averageif function to find the average of individual cells as a total, ignoring blank cells, but include zeros. At the moment, I have this =averageif(e9,k9,q9,w9,ac9,ai9,”<>0”) However, the cells ac9 and ai9 don’t get selected and I don’t know why? Any help?

Hello, I have some code that copies and pastes data from cells in certain workbooks into columns in the main workbook. When running this, the ary 0-3 seem to be mixed in order when pasted and come up with some blanks when there are none. I do not have the code available at the moment but I...

.... I have 3 cells (vertical), that contain R,G,B values. These "boxes" of the 3 cells is repeated 255 times, making 256 * 3 cells in total. I want all 3 cells in each "box" to be coloured to those RGB values, whenever any one of them is changed. I'm having a mental block at the moment, and...

hi all. I'm wanting to create my own formula function, but not too sure where to begin.. basic; =WhichState(A1) <tbody> 3931 VIC 4000 QLD 6000 WA 2011 NSW </tbody> at the moment i'm using a =left, plus a vlookup and its a bit messy, and it gets used in a ton of my spreadsheets.. any...

Hi Guy's Any idea how to I turn my data output from this.... <colgroup><col><col><col><col span="3"></colgroup><tbody> 201309 201310 201311 201312 201401 A 13000 18266 15300 7250 25050 B 0 15568.9904 15000 16900 47040 C 0 0 0 8750 126082.4 </tbody> to this very quickly please...

Hi all, I have a timesheet which we do our daily hrs tracking. we have diffrent pay rates and there for i want my time tracking to show me diffrent sections this is the formula at the present moment but it calculates all: =SUMIF(TimeLog!$A$20:$A$2146,"=YES",TimeLog!$G$20:$G$2147) i now need...