Search results

Looking for a little help to change a cell that contains "17/15/13" . into individual cells that contain 17 15 13 respectively

=SUM(SUMIF('February 3, 2014'!$L$2:$L$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$M$2:$M$58,D4,'February 3, 2014'!H2:H58)+(SUMIF('February 3, 2014'!$N$2:$N$58,D4,'February 3, 2014'!H2:H58)))) Is there an easier/neater formula than this?

What's the best way to insert large data into a table. When I insert more than a few item into a table, the file freezes/locks up. The table has 1500 rows with two col with formulae and one with some conditional formatting. To insert the new rows of data, I have to first convert the table to...

http://speedy.sh/gntvM/PM-Tracking-Log-Final.xlsm The link is to a back up copy of a workbook I use to track preventive maintenance. The original workbook became corrupted and would not function, i.e. the macro would not run. Some background: Hui helped me out quiet a bit with the macro, the...

I have a workbook (Hui wrote most of the code, thanks again) w/a userform that allows the user to enter an equipment name a date and a technicians name into a table. Getting a little comfortable w/the code so I made some changes to the ws, just deleted a few cols that I didn't need and added...

I have a table w/ a col that contains dates. I created a pivot table and try to sort by dates but I only get "Label Filters" and "Value Filters". Why don't I see the "Date Filetrs".

I want to add a cell w/shape and a macro assigned, that will move a chart from one ws to another. I tried recording the macro but that only works once then.... errors.

I am using a number of cells to allow the user to set the Print Area based on the text in a cell. BR in the below recorded macro. The cells are in A1:G3. I used Dwg tools, made a box, 100% transparent and placed them over the cells. 1) Easier way than rec. individual macros and 2) How can I...

I have a workbook w/15 worksheets. Each ws has 1 or 2 named ranges for date col and name col. Using this formula to sum two criteria- persons name and a date(...today -365)...

Name- brdate, refers to 'BR 8-14'!$D$3:$D$35, used in formula =COUNTIF(brdate,">="&$K$15). How do I make range dynamic so if I add a row at the bottom of the range the range will change.

Col S uses forumla =IF(Q4="","Overdue",IF(Q4>TODAY(),"Not Due","Overdue")) On a seperate worksheet, I have formula =COUNTIFS(Sheet2!A4:A1746,"BR",Sheet2!S4:S1746,"Not Due") gives a zero. Cell A4 = "BR" Cell S4 = "Not Due" How does COUNTIF or ...IFS work when a cell is populated by...

D1:D36 have dates. =COUNTIF(D1:D36,">4/12/2011") gives the cells > 4-12-2011. What if I want to count the cells > today()?

Looking for a way to delete entire rows based on multiple criteria. Any suggestions.

Is there a way to save a post (i.e. a draft copy) , to refer/send at later date?

=IF(ISBLANK(B210),"",IF(LEFT(P210,2)="SD","Slave Driven",IF(R210="-","","480v AC"))) If I use this formula in an blank worksheet w/bogus data, I don't get an error;it looks like it works fine. When I enter it into a database from an outside source i.e origingal equipment manuf. Excel kicks...

I have a large equipment database that a manufacturer created when our distribution center was built. In each cell, there is a "tick" mark (i.e. 'BELT CONVEYOR) preceeding the data. The mark is not visible when unless the cell is selected. Any significance to this, where does the mark come...

Just wondering if anyone has run into this error. I get this error when I attempt to download from a Computerized Maintenance Management System database (Maximo) to Excel. Never got this error w/previous Office versions. Not getting anywhere w/own IT people. The file you are trying to...

I copied/pasetd the following code from another website to enter the date when something is updated/entered. So if anything is entered in cells the corresponding cell in col B is updated w/NOW(). Doesn't seem to work. Any suggestions? Keep it simple 'cause its 2am and VBA is almost Greek to...

I've been working on a table/userForm for awhile now. His "Excelence", Hui, has given me quite alot of help. No one better. I'll give him a break and ask this question Col O Col P 4 12/1/2010 12/30/00 (=IF(ISBLANK(O4),"",Table1[[#This Row],[PM Comp Date]]+365)...

I have a small spreadsheet w/1700 rows of Assets ("Unit #). Column C is "Unit #", Col O is "PM Comp Date" col. Q is "Technician". The UserForm has 3 text boxes for the user to enter Unit #,PM Comp Date and Technician and also has two command buttons; 1 to Update Asset data and one to close the...

I hid all of the cells in a worksheet that were empty. How do I unhide??

For the holidays I'd like to create a worksheet that has a command buttons that when clicked, randomly generates a name from a list (A1:A17) and removes that name from the list to avoid duplicates.

has anyone figured the date and time picker. After creating a drop down calendar and then opening the worksheet up again, the drop down window needs to be resized every time. Also, there's no way to copy and paste a calendar to multiple cells.

I have a worksheet w/data that is used in a Pivot Table. The data contains cells such as: A B 1 Area Unit # 2 UP 12 3 UP 12SL1 4 UP 12SL2 When I sort by "Area", the Unit #'s w/SL1 or 2 get sorted at the bottom of the columns. How can I...

A1 B1 1234-TL TRAILER LOADER If cell A1 contains "-TL" how can I format B1 to read "TRAILER LOADER"