b1

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

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

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

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

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

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

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

ORACLE FORMS-pop list index retrieval

Hi,I have the following problem with a poplist. a. Retrieve all the values and the list index(eg: 1,2,3) from the list item and store them in a pl/sql table. b. When a value is chosen from the list,I need to get the list index from the list for that chosen...

Tags: B2, list index, madan_bharatwaj@..., Oracle Corp., software, Value at Risk

Discussion threads 2005-03-13