Pages

Search

Excel Help Forum - Excel Formulas & Functions: MSE 2002 Alternative to Weeknum

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
MSE 2002 Alternative to Weeknum
Hello, What can I use to replace Weeknum in 2002 which bases its result to a column of dates?

Excel Help Forum - Excel Programming / VBA / Macros: Match Headers, Copy from raw data and paste it horizontally

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Match Headers, Copy from raw data and paste it horizontally
Hi, Can someone please help me with this? I have attached a sample pic for this report. I am trying to create a macro to copy from raw data(first picture) according to the heading on the top(Name, Number, Subject) Attachment 188438...

Office IT Pro General Discussions Forum: Error when upgrading from Office 2003 to Office 2010 with a domain user

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Error when upgrading from Office 2003 to Office 2010 with a domain user

When upgrading users from office 2003 to 2010 when I open office I get error ID:1000 and it tries to open in safe mode but this also fails. The only way to solve the error is to remove the users profile and then log back in as the user then it works correctly. Any ideas why it doesnt allow Outlook to open unless I remove and log back in the users profile? We all use Windows XP.

Thanks,

Liam Earnshaw

Excel Help Forum - Excel General: in Vlookup/Index / match-how to update content in 2 or 3 row of different column

Feed2Mail notification - new post on Excel Help Forum - Excel General
in Vlookup/Index / match-how to update content in 2 or 3 row of different column
Hi, I have two tables. I want to update contents from one table to another table. I have tried to use vlookup, match, index, two way match/index, helper column But it update only contents in first row but skip second or any successive row even if it is in diffetnt colum. I have attached...

Excel Help Forum - Excel Formulas & Functions: Move from column to row according to criteria

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Move from column to row according to criteria
Hello everyone, I have attached a worksheet showing what I'm trying to do. Basically I need to get/concatenate all the text for all the Name 1's into one cell and the same for Name 2's etc. I have a list of over 3,000 names so i'll just want to be able to drag a formula down. I started...

Excel Help Forum - Excel Programming / VBA / Macros: Help with Select Change Event

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help with Select Change Event
Hello All, I am currently working on a small personal project and trying to learn VBA concepts. Could anyone help me with applying select and change? Basically I have a couple of functions within my module that collect average, minimum and maximum etc in one sub. I want to be able to...

Excel Help Forum - Excel General: I can not input numbers in a cell.

Feed2Mail notification - new post on Excel Help Forum - Excel General
I can not input numbers in a cell.
Hi everybody, Good day to all. I have problem. I have to input some data on my excell. It has 'TIN', 'Name', 'Father's Name', 'DOB' & 'NID'. when put 198710410947000002, but it shows 19710410947000000. Help please!!!