moment

  1. D

    conditional formatting 2 colours for a cell.

    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...
  2. G

    Can anyone help on how to extend and amend a V LOOK UP

    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...
  3. L

    Return certain rows from a separate tab if a condition is met

    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...
  4. P

    How to shorten if or formula ?

    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...
  5. K

    Custom Print Pages VBA

    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...
  6. M

    Multiple values returned based on criteria

    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...
  7. W

    Formula needed!

    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...
  8. D

    Simple IF statment

    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.
  9. D

    Copy data and paste everything

    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?
  10. S

    combined vlookup & if

    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...
  11. S

    VBA/Formula

    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
  12. Trevor3007

    multi attachements

    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
  13. U

    Hide all multipage

    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...
  14. G

    Excel formula at the moment

    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...
  15. N

    Averageif ignoring zeros/blanks not working

    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?
  16. J

    Fixing ary copying and pasting

    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...
  17. D

    Cell-colouring macro

    .... 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...
  18. A

    Custom vlookup function?

    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...
  19. B

    Transpose Data.....I think

    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...
  20. C

    Splitting diffrent hrs for diffrent rates

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top