On BNET: Master work-life balance
1 Resources for

c1-1

  • Subscribe to this listing via:
  • RSS
  • Email

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


IT Hardware and Software Purchasing Policy
Your IT Budget is tight. You want to get the most bang for your IT buck. That's where the IT Hardware and Software Purchasing Policy can help.

Thi ...

Buy Now
Harness the Full Power of Internet Explorer
This pre-packaged presentation contains everything you need to instruct end users about how to the most out of the Internet and Internet Explorer--eve ...
Buy Now