Pages

Search

Excel Help Forum - Excel Formulas & Functions: advanced excel counting with running totals

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
advanced excel counting with running totals
I have an excel spreadsheet--in which I cannot use VBA (for security reasons)--and I am trying to count cells. Each day that an occurance does not happen, an accident for example, I add 1 to the current day (for weekdays) and one for each weekend. However, if an occurance does happen, I need to...

Excel Help Forum - Excel Programming / VBA / Macros: Need help in Search database

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Need help in Search database
Hello! I am building a search database. The data that I have is captured as below (Just an example of how the database looks Index1 | Index2 | Data1| Data2 | Data3 10 | 50 | A | B | C 100 | 150 | X | Y | Z

Excel Help Forum - Excel General: VLookup Syntax required to look up period date if I put 'Yes' in a cell

Feed2Mail notification - new post on Excel Help Forum - Excel General
VLookup Syntax required to look up period date if I put 'Yes' in a cell
Hi, could anyone please advise me of the Vlookup syntax to look up the current period dates from a range of period dates if I put 'Yes' in a cell? What I have is a workbook with two worksheets i.e. 'This Period' and 'Admin'. The 'Admin' tab has this finacial years dates in columns C & D...

Excel Help Forum - Excel Formulas & Functions: Counting number of times a word appears across worksheets

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Counting number of times a word appears across worksheets
Hi , Basically I have created a spreadsheet with details of several different people for HR purposes. Each person is assigned to a worksheet called 'People Info' and I have 70 copies of that worksheet with each persons details on. One of the criteria is each persons work status which has a drop...

Excel Help Forum - Excel Programming / VBA / Macros: numbers with `comma style` in text format

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
numbers with `comma style` in text format
Hi all, I`ve got a database, in which few columns are filled by the numbers in general, accounting or custom format, but for all of them `comma style` has been applied. So they look like this: 32.200,00 119.850,00 38.608,00 11.970,00 11.970,00

Excel Help Forum - Excel General: Automatic enter

Feed2Mail notification - new post on Excel Help Forum - Excel General
Automatic enter
Hi Forum, You've helped me out before with this, but this time its a bit more complicated and I need expert advice. I'm looking to have excel automatically enter to the next line - but only after it has went to column A and B and then enter. I'm looking to use a barcode scanner to scan...

Excel IT Pro Discussions Forum: Microsoft Office 2010 External Data Link Reference Issues

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Microsoft Office 2010 External Data Link Reference Issues

We have upgraded Microsoft Office 2003 to Office 2010 Professional in our premises. Mostly in Excel 2010, users are getting issues with update in external link references, like link references are getting changed or not getting updated most of the time and also files are taking longer to get opened. 

Most of the desktops having this issue, running on windows 7 professional 64-bit with Office 2010 Professional 32-bit version. 

Whether this can be reason? Or it is necessary to keep 64 bit version of Office with 64-bit Operating System?

Kindly adv. 


Subscribe to: Posts (Atom)