Pages

Search

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!!!

Excel Help Forum - Excel Charting & Pivots: 1 pivot out of 2 columns, but different ranges

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
1 pivot out of 2 columns, but different ranges
Dear all, I want to make a pivot with how often an ID was used during that week. For example ID C7214 in week 3 (3 times). This is the count function, I can manage this one. But now the hard part. I also want to know how often the unique ID is used that week.. For example ticket C7214 in...

Excel Help Forum - Excel Formulas & Functions: How to set formular sumif or countif?

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
How to set formular sumif or countif?
I'm beginner of Excel formula setting. Please kindly help me to set formula as the picture below Attachment 188424 (http://www.excelforum.com/attachment.php?attachmentid=188424) How to set formula sumif or countif or any formula for calculation total number of days in Sick and Errand leave...

Excel Help Forum - Excel Programming / VBA / Macros: Hyperlink produced when content of cell is placed in userform textbox

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Hyperlink produced when content of cell is placed in userform textbox
Hi I have spent a considerable amount of time researching this excellent resource and learnt a great deal since joining the forum, but I cant find the answer to this. I have a User form created with a number of fields. One of the fields needs to be a hyperlink that is created once the file...

Office IT Pro General Discussions Forum: Using AudioFrames in Power Point 2008 for Mac (PPT format)

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Using AudioFrames in Power Point 2008 for Mac (PPT format)

Hi,

I was redirected to this forum from this thread.

I use PP 2008 for Mac. Create a new presentation (/testfolder/test.ppt), adding audioframe with external file (/testfolder/subfolder/test.mp3), save presentation in PPT format. Result was successfully opened in PP 2011 for Mac, but does not works correctly in all Power Point versions for Windows (wrong path to the audio file).

The same presentation but created in PP 2007 for Win does not works in PP 2008 for Mac (but works fine in PP 2011 for Mac).

I think that PP 2008 for Mac generates files (with audio frames), which can be used only in PP for Mac. So PP 2008 for Mac can't work correctly with files which generated in Windows versions of PP.

I would like to receive comments on the issue.

Subscribe to: Posts (Atom)