| Thread | Last Post | Replies |
|
| Alternative to a drop down list | 06 Sep 2007 15:28 GMT | 3 |
Hi, I have designed a requisition form. The first work sheet "req" in the spreadsheet is a form that links to 3 other worksheets in the spreadsheet. In the "req' worksheet, Officers select a supplier from a dropdown box. It then does looks ups (Vlookups) based on the supplier ...
|
| VBA Code for Deleting a Row | 06 Sep 2007 15:23 GMT | 3 |
I would like to use a macro to delete any row that has the word "delete" in one of its cells. What would this code be? Thanks!
|
| pop up calander in an excel spreadsheet | 06 Sep 2007 15:22 GMT | 1 |
I'm attempting to create a popup calander in an excel spreadsheet to be able to choose a date and fill in a field. How can I create it?
|
| Complicated formula help needed please | 06 Sep 2007 15:17 GMT | 2 |
Is it possible please to create a formula where Sheet1!A2 = the count of Sheet2!C* where Sheet2!A*= Sheet1!A1 and Sheet2!B* contains "String" Thanks
|
| I wish to fomat numbers in Excel | 06 Sep 2007 14:55 GMT | 4 |
so that 0's follow:if I enter 123 then 123000 will enter.
|
| unable to solve array formula syntax | 06 Sep 2007 14:24 GMT | 2 |
I'm confounded by what I think should be a rather simple formula -- I think an array formula. Here's what I have so far: =SUM((DateAll)*(WeekdayAll="1")*(quarter="Q1")*(Fiscal="F2008")) Date"All is a named range of numbers
|
| if then statements | 06 Sep 2007 14:22 GMT | 6 |
I haven't used in forever and now need... I have cells formatted custome as 0;-0;;@ so that if there is a 0 it won't show and become visually in the way, but now the other problem that I need is if the cell (e9) above my cell (e10) is equal to or lesser than the formula should ...
|
| Lookup and return value 12 rows below | 06 Sep 2007 14:00 GMT | 5 |
I am trying to find a formula to lookup in a table and return the value to the right 12 rows below. In the example below my search value is 02-2007 and I would like to return the value 36.000 which is 12 rows below next to 02-2008.
|
| New sub-folder in Excel using a formula | 06 Sep 2007 13:56 GMT | 1 |
I would like to read a cell value then create a Windows folder using the value in the cell as the folder name
|
| What is the furmulla to extract Rs.44325/t | 06 Sep 2007 13:23 GMT | 2 |
if any one have excel functions file then please send in my email Id narender.gupta@hotmail.com
|
| Get all Sundays | 06 Sep 2007 12:01 GMT | 4 |
what I want to do is put a year in A1 and return the first Sunday day date in cell A2. The second Sunday day date in A3. The third Sunday day date in A4 and so on. Then all I need to do is change the year and the cells will reload to the correct day dates. Is this possible? I am ...
|
| Concatenation Formula needed | 06 Sep 2007 09:56 GMT | 5 |
I am trying to joins 2 text fields in columns a & b. Column A is a variable field of differring lengths and characters in every row. Column B is the same string in every row of 7 characters long.
|
| Rating according to 2 criteria. | 06 Sep 2007 09:24 GMT | 5 |
On a spreadsheet at work, used to silent monitor incoming phone calls and the way they are handled, we look our for 4 characteristics. Under each of these headings are, at present, 7 items we look out for. Everyone starts with 100% score for each characteristic and loses a point ...
|
| IF function and wildcards | 06 Sep 2007 08:48 GMT | 6 |
Is it possible to use wildcards in an IF function to test a text string in a cell. I have a cell that could contain 2 text string options "300 Denier Polyester" or
|
| filtering rows depending on onother sheet | 06 Sep 2007 08:46 GMT | 3 |
I need help - please: I have 2 Excel sheets: 1 – Contains all contact details (aaprx 900 rows) 2- Contains email addresses which have bounced back over the past 3 months
|