Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Pass Variables betweent forms
- I have an access database the is used to track project status. The part I am having trouble with is passing variables between forms. I have my project form and it has a subform that displays the tasks for the related project. The project ID would be...
- Tags: Programming languages, Databases, C1-1
- Q&A 2006-02-06
Additional Resources
- Chevrolet Corvette C1 (EXE)
- Chevrolet Corvette C1 screensaver displays high quality images of Chevrolet Corvette C1. This version is the first release on CNET Download.com.
- Tags: Screensaver, Quality
- Software downloads 2007-11-29
- Autometic express of numeric value in text in MS exel.
- Suppose in A1 cell a vale inserted 100 and in B1 another value 200 is inserted. Now If C1 cell represent A1+B1=C1 i,e, C1=300 then how this 300 value can autometically typed in text in another Cell D1 i,e, in D1 "Rupees Three Hundred Only" can autometically generate. Remember every...
- Tags: rajusahantc@..., Microsoft Corp.
- Discussion threads 2007-04-13
- Excel Formula
- Bear with me as I try to explain my problem. I have a table that has in cell A1 'Apple' and and B1 '15'. Then using cell C1:D3 as a sort of reference database or lookup table fill in C1 'Apple', C2 'Orange', C3 'Lemon' and in D1...
- Tags: Microsoft Excel, alan@..., Apple Computer Inc.
- Discussion threads 2007-05-17
- Excel - Sum and Average every other row
- I have an Excel spreadsheet that has data in every other row starting in cell C2 and ending in cell C62. I am trying to get my spreadsheet to calculate the average of all of the data in these cells. I know how to do an average formula,...
- Tags: Microsoft Office, Rosstamon, cell, Microsoft Excel
- Discussion threads 2007-07-31
- Excel 2003 Formula Question Calculating postage from weight
- I have a excel document that each product has a per piece weight and quantityi want to quantity*weight for gross weight then select a postage price a given set of weightsie 0 - 249 250-499 etcVALUESF7 QUANTITY G7 WEIGHTC1 LOW WEIGHT D1 HIGHWEIGHT E1 POSTAGE THROUGH TO C8 - D8...
- Tags: kryan@..., feedback, Microsoft Excel
- Discussion threads 2007-02-15
- Excel Row Heights
- With excel, you can find & show a column width of a cell by entering =CELL("WIDTH",C1), were C1 can be another cell, or the cell of the formula.Now, how can I do the same thing for the Row Height????no function butyou can do it in VBShttp://tinyurl.com/y46ehmI'm assuming there isn't a...
- Tags: cell, excel, Microsoft Excel, RogerAIA@..., row format, software
- Discussion threads 2006-10-18
- Active Directory Profile Path
- I have a question regarding the creation of user profiles whenthe account is created.I understand that in the profile sections of a user object, you can assign home folders and profile paths for roaming profiles. I also understand that you can use variables like %username& to create the folder...
- Tags: &B1&, BlitzSonik, folder column, home folder, home folder column, Microsoft Windows Active Directory, windows
- Q&A 2006-01-18
- Excel
- Hello!Can you tell me more please about Row differences and Column differences in Edit, Go To Special dialog box? That answer still not enough clear and it is the same answer in «How to use the Advanced Excel Select».Thank you!Mona R.If you have following data:1 2 32 ...
- Tags: cell, zimonar@..., windows, Microsoft Excel
- Q&A 2006-02-05
- Use Excel to calculate the hours worked for any shift
- Calculating hoursThis was great & perfect timing since I'm trying to update the timesheets here. Question for you, I want to build in an option to deduct time for lunch, while still calculating everything properly. I also want the total column to work correctly regardless if they took...
- Tags: parenthesis, cell, decimal
- Discussion threads 2005-06-29
- How to refernce a static increment of rows in one column,ie every other
- Example: I would like to reference cells c1:c5 to the values in cells a1, a5, a10, a15, a20.Thank you to responders
- Tags: yonatan.t.carl@...
- Discussion threads 2007-05-28
- Excel argument/formula question
- Let's say I have the POTENTIAL to have data in cellS A1, B1, C1 and D1. In cell E1 I want to add all four cells together. That's easy. Now in cell F1 I want to say take the total from E1 and divide it by the...
- Tags: Rosstamon, Microsoft Excel, A1:D1, cell
- Discussion threads 2007-07-13
- TransposeFunctionalityin ExcelWorksheet?
- I have never used this Transpose Function before.Can anyone help me with Code so that I can transpose rows into columns and vice versa, using VB.net Code. ...
- Tags: Programming languages, Scripting languages, r_nair83@...
- Q&A 2006-05-08
- Save time in Excel with automated reports
- Can We Create Unique SaveAs Filenames?Thank you for this tip, I think it's will be very useful for me. I'm trying to retrofit it to use in our current expense report template. I was wondering how I could make the "SaveAs Filename" unique. Would it be possible...
- Tags: Microsoft Excel, Richard Noel, filename, YYYY-MM-DD, e-mail
- Discussion threads 2007-10-24
- Use Excel to obtain a random sample of customers for market analysis
- No matter whether you are testing a new marketing campaign or evaluating your current level of customer service, you want to be sure that you base your analysis on a reliable sample of your customers. For example, you would like to use a random sample of 200...
- Tags: Analysis, Microsoft Excel, Microsoft Office, Office Suites, Software, Mary Ann Richardson
- Blog posts 2007-11-27
- Moving data in Excel
- I have an excel spreadsheet template with multiple formulas. Users do not access the formulas but they have a horrible habit of dragging the bottom row of data to the top and then filling down when starting a new form. This throws everything out as now the last formula is...
- Tags: Microsoft Excel, damian.murphy@..., cell
- Discussion threads 2007-10-03
- Transpose rows into columns & viceversa?
- I want to transpose rows into columns and vice versa in excel sheet using vb.net.And also the values should be sorted. For EgOld Format: A1 B1...
- Tags: cell, Value at Risk, r_nair83@..., programming
- Q&A 2006-05-09
- Set up minimum and maximum markers on Excel line charts
- Let's say that at the end of each month you provide your sales personnel with a line chart that charts year-to-date sales by month. For the June report, you would like to emphasize which month had the most sales and which month had the least sales. You could manually add...
- Tags: Microsoft Excel, Sales Strategy, Microsoft Office, Sales Force Management, Office Suites, Software, Sales, Mary Ann Richardson
- Blog posts 2007-10-02
- Formulas in Excel
- I have created a formula in Excel as below: =SUM(IF(Data1!B1:B155=B9, IF(Data1!C1:C155=AD10,IF(Data1!I1:I155 = 2, Data1!L1:L153,0),0),0))But it is not displaying the result in the cell. If i am in the formula and do a F9 Calculate it will bring the correct result through but will make the formula disapear. How can i...
- Tags: feedback, Microsoft Excel, off-topic, simon_sez_it@...
- Discussion threads 2007-01-11
- Sum values within a certain date range in Excel
- Why the & symbol??I actually ran into this challenge last week, trying to use SUMIF and the TODAY function. Someone pointed me in the direction of concatenating the comparison operators with the TODAY function name, but I don't understand the rationale behind it. Can anyone clue me in?To take this...
- Tags: DueDate, excel, hardware, LicenseFee, Microsoft Excel, SumIf, wittmav@...
- Discussion threads 2006-03-29
- << Previous
- page 1 of 1
- Next >>
