-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
data comparison
-
J
PowerBI Comparison between dynamic daterange.
Hi Guys, I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change. Please help! Thanks &... -
P
Coloring cells based on data from other sheet
Hi, I have problem with this formula: Sub Cell_color()Dim MyWorkbook As Workbook Dim Matrix As Worksheet Dim Help As Worksheet Dim Data As Worksheet Set MyWorkbook = ActiveWorkbook Set Matrix = MyWorkbook.Sheets("Matrix") Set Data = MyWorkbook.Sheets("Data") Set Help =...- PWSY86
- Thread
- Replies: 2
- Forum: Excel Questions
-
S
Any number in a column is greater than last one entered
Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following: Consider that Column E needs to contain a list of dates. 1. I need a formula...- skyport
- Thread
- Replies: 6
- Forum: Excel Questions
-
T
flag or highlight when number entered exceeds a set value in relation to previous cell
Okay, don't know if that Title will do it. However hopefully someone can help me with the following. I think it is conditional formatting that I want to use, but it doesn't seem to be quite right. I have a row of numbers and I want to have the system notify me or colour the cell or in some way...- tchelen
- Thread
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...