-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
@excel questions
-
I
Getting notes in a table to move when Vlookup data changes
Hi there, Does anyone know how I can get my notes made in a table to move/stay with the data it was made for? I have a table in sheet 2 that pulls profile data using a Vlookup from sheet 1 that contains all of the profiles/raw data. The table filters out the data based on certain criteria (I...- itachi123
- Thread
- @excel questions
- Replies: 0
- Forum: Excel Questions
-
K
#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Follow Condition )
#Get data "Sheet 1" to "Sheet 2" in excel ( Check in Image , Sheet 1 many Spaces in there , So i Need "invoice Number list" on Sheet 2 (Auto Generated) how to possible get data as a list format, NOTE: SHEET 1 : *** So many Space in there*** SHEET 2...- krunal123
- Thread
- @excel questions condiational formatting excel excel "multiple strings" excel & lookup excel & lookup & search query query conditional power question/answer reference cell formula
- Replies: 1
- Forum: Excel Questions
-
K
Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???
i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????- krunal123
- Thread
- #easyexcel #matching #searching #vba #excel #pleasehelp @excel formula @excel questions @excelvba conditiaonal formatting conditional cell colour excel & formula excel & ilogic excel & lookup & search excel formula help formula #explaination mr. excel pivotable powerquery vba & conditions
- Replies: 1
- Forum: Excel Questions
-
K
We Need Only TEXT Contain, How to possible in Excel Formula ????
All Number list is Same Len ,if Number After Single Space , We Need Only TEXT Contain ,How to possible in EXCEL formula .......- krunal123
- Thread
- @excel questions advance formula condition formatting easy excel tricks excel formula excel query excel tips excel tutorial pivottable power query advance vba
- Replies: 3
- Forum: Excel Questions
-
K
How to Possible match "List-1" & "List-2" Both number match & show Result "List-2" in item cell ???
Condition-1 Match List-1 & List -2 Number & Show result in list-2 "item" Cells........- krunal123
- Thread
- @excel questions excel excel conditional formatting excel formula excel logic excel query pivot table
- Replies: 3
- Forum: Excel Questions
-
K
How to multiply cells belonging to specific month of a year and company name?
My input is daily data from 2001 to 2016 for 200 companies. The output is monthly data (Here I calculate "Product" in June, 2000 = product of all "(RD/100+1)" in June 2000: <tbody> A B C D E F G H I J 1 2 Company Price Close Date Daily Returns Daily Data Company Date...- kursenkoalla
- Thread
- @excel @excel questions
- Replies: 1
- Forum: Excel Questions
-
R
Formula r1c1
Hi Guys Please help me to this code ActiveCell.FormulaR1C1 = "='Common Costs!RC[6]" instead of common cost sheet what code should I put if the next sheet is the destination of formula.- raymondemn
- Thread
- @excel questions @macro @programming @vba
- Replies: 1
- Forum: Excel Questions
