1 Resources for

b1:b40

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

MICROSOFT EXCEL 2003: Can anyone help. IF THE LETTER "A" IS ENTERED INTO A CELL BETWEEN (A1:A40) THEN THE NUMBER Fig"1" IS PLACE IN CELLS (B1:B40) If another "A" IS ENTERED BETWEEN (A1:A40)THEN Fig "2" IS PLACE IN CELLS (B1:B40)AND SO ON NUMBERING CELLS IN SEQUENTIAL ORDER 3,4,5. SO IF THERE ARE 5...; Tags: A1:A40, arrays, B1:B40, buzby@..., excel, feedback, formulas, Microsoft Corp., Microsoft Excel, off-topic, programming, windows; Discussion threads 2007-01-19

Additional Resources

Excel formula: Please help Value in Cell A1 is copied into cell B1 and new value is entered in A1B1 should now show old value of A1 plus new value of A1in other words B1=B1+A1How do I do this in Excel. Tried to use if statement, cant figure it outThanksYou will need...; Tags: ichu50, Microsoft Excel, software; Q&A 2005-08-20
Two Broadband connections and One SBS 2003 server: Hello, I have two broadband connections(one with 256kbps and other with 512kbps )with me and the server has two network adapters.[Two broadband connection because if one A1 goes downor is dead Internet operates on other B1.] Now, can I merge these (A1 and B1) in Two N/W adapters on my...; Tags: acmahajan@..., broadband, hardware, it management, Microsoft Windows Small Business Server, Microsoft Windows Small Business Server 2003, network management, networking, server, windows; Discussion threads 2007-01-08
two wireless networks: We have two wireless networks let us call it as A1 and B1 now when i am connected on Network A1 i am able to browse the netwwwand are able to do regular work with ease.when i am connected on network B1 i am not able to browse the netwww,and...; Tags: acmahajan@..., it management, network, Proxy Server, wireless, wireless network; Q&A 2006-09-28
excel problem: I need to find the form to get the real timefor example01/08/2000 to 01/08/2007so the diferences is 7 yearsbut I don´t know how to do it just I wante the diferences....the result = 7 yearJust subtract and divide by 365.25If you place those two dates into cells (say, A1 and...; Tags: edaen.bedolla.temp@..., B1-A1; Discussion threads 2007-08-01

Excel macro page breaks and footers: Hi, my users get a csv file every month, and we run a macro to clean it. My last issue is having the spreadsheet create page breaks whenever the value in column B changes. Below is that code:col = 2 LastRw = ActiveSheet.UsedRange.Rows.Count For X = 2 To LastRw If...; Tags: B1, Cell, Microsoft Excel, misscrf, software, X; Q&A 2005-10-06
Bad motherboard or bad memory?: So a fatal error in Xp left me in this situation.Quick run down is, i have two sticks of 512 3200 DDR memory, and a A8N32-sli Deluxe mobo.Stick1 works in all slots (a1 a2 b1 b2)Stick2 works in a1 a2 & b2 onlyWhen ever stick 2 is placed into the...; Tags: TV & Home Theater, Now-What, cebaxx@..., A1-A2, memory; Discussion threads 2007-10-26
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
microsoft ECXEL help: Please helpcell A1 to A5 has a text value and cell B1 to B5 has a number value, if cell B1 to B5 present a negative value how can i automatically transfer or populate that negative value to C column and also transfer the text that represent that negative value...; Tags: Microsoft Corp., russellte2002@..., cell; Discussion threads 2007-05-17
Take advantage of Excel's DATE function: better solutiontype date in a1type 'day-of week'in b1type =text(a1;'dddd') in b2enter date in a1 and you will get the day in b2!Help with perpetual date please!I feel stupid. I thought I followed the formula but it isn't working for me. I get an error telling me the formula...; Tags: ecx@..., Microsoft Excel; Discussion threads 2004-11-01
Create a formula for entering a series of incremental times in Excel: You can have Excel enter time increments in your worksheet automatically. Mary Ann Richardson shows us how to set up a formula for entering a series of increments in Excel. Suppose you're working in Excel and need to record the price of a certain stock every 15 minutes...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, Microsoft Office Suite Access Tips Newsletter, Office Suites, Software; Technical articles 2006-02-28
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
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
two wireless networks: We have two wireless networks let us call it as A1 and B1 now when i am connected on Network A1 i am able to browse the netwwwand are able to do regular work with ease.when i am connected on network B1 i am not able to browse the netwww,and...; Tags: acmahajan@..., it management, network, wireless, wireless network; Q&A 2006-09-26
Anatomy of an Excel formula: Using functions to perform calculations: CorrectionsThe textIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and B1, inclusive of A1 and B1". should readIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and D1, inclusive...; Tags: hardware, lschell, Microsoft Excel,; Discussion threads 2005-08-23
Connecting IF Statements: I've spent considerable time trying to create an IF statement that represents the following:if b40 = 1 and b54 =less than 100 then b31, greater than 100 but less than= 200 then b32, greater than 200 but less than 300 then b33, greater than 300 but less than 400 then...; Tags: lbrown@...; Discussion threads 2007-08-14
Two Wireless Networks: If we put both the wireless routers on the same switch so that the wired desktop and wireless laptops that are connected should be able to surf the internet,then it does not work , or it may have a conflict........soWith two wireless broadband connection (A1 and B1) when i connect...; Tags: acmahajan@..., broadband, desktop, it management, network, router, swITch, wireless, wireless network, wireless router; Q&A 2006-09-29
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
Excel nexted functions: I'm trying to count student attendance if they are Special Education students, ie =if(f15="P"+ae15="1"),1,0 (if one cell is "P" AND another cell is "1" then return "1")This returns "invalid" or "value" and function doesn't work. When I get the function to work, it returns an incorrect value. How...; Tags: A1=P, B1=1, blginger@..., C, cell, COUNTIF, Microsoft Excel, software, Special student; Q&A 2005-12-24
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

<< Previous
page 1 of 1
Next >>

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

Disaster Recovery Plan Power Checklist: Development of a disaster recovery plan is a must. Although there may never come a time when the plan must be implemented, it is always best to prepar ...; Buy Now