-
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.
xl2007
-
S
Trouble interpreting date range. Excel2007
I am trying to build an Equipment Replacement Schedule for computer hardware. I have a column that reads the warranty start date and adds the number of years that has been determined as the replacement cycle. That looks like this...- sdandolini
- Thread
- Replies: 12
- Forum: Excel Questions
-
1
Get Excel 2007 to consider only filtered cells
Hi, I have put on a filter in my sheet and want to copy certain values from Column W to column X with the filter on. However, when I copy across the values with the filter still on it is ignoring the filter and just replacing the values sequentially. For example with the filter on I have rows...- 1021557
- Thread
- Replies: 5
- Forum: Excel Questions
-
where do I find the selector in XL2007?
Hi Where do I find the selector in XL2007 so that I don't have to manually select each shape? I want to grab an entire selection in one shot! I still hate this ribbon! :mad: Thanks Jon- Jon von der Heyden
- Thread
- Replies: 3
- Forum: Excel Questions
-
A
Conditional Formatting XL2007
Hi All XL2007 includes some supplied conditional formatting rules/formulas. Is there a way to "reveal" the actual formula code behind these supplied conditions, not just their "english" description? Regards AlMorl- AlMorl
- Thread
- Replies: 1
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
problem function date add into datepicker on userform
- Started by abdelfattah
- Replies: 48
hi i have problem add years and months days is ok i have textbox1= days textbox2= months textbox3= years when i... -
Vlookup Help
- Started by tomehta
- Replies: 35
Hello In attached excel screen shots, in Col I (sheet 1), I want Col C value (from sheet 2), similarly in Col P (sheet 1) want Col D value( from... -
Split cells based on specific text which may occur multiple times in cell
- Started by charlie_580
- Replies: 25
Hi I wonder if anyone can help? I need to split multiple cells by code, however the code may occur within the original cell more than once. and... -
AVERAGE RANGE CELLS DD:HH:MM FORMAT
- Started by LawNapier
- Replies: 25
I am trying to average the below in DD:HH:MM format. The cells format is set as "custom > DD:HH:MM". I want to only average the time for the... -
Need to color specific cells on another sheet automatically
- Started by csteps
- Replies: 23
Need the cells listed in yellow to color those cells on another sheet automatically [ATTACH type="full"]14354[/ATTACH] -
Move Files To Dynamic Folders Based On Cell Value
- Started by wells
- Replies: 22
Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100...