here is the formula I use to combine date columns from two sheets in the same workbook.
=IF('TD8 sd7AL'!A30>0,(IF(ISNA(VLOOKUP('TD8 sd7AL'!A30,'TD6 sd7AL'!A30:A274,1)),'TD8 sd7AL'!A30,VLOOKUP('TD8 sd7AL'!A30,'TD6 sd7AL'!A30:A274,1))),NA())
It works for two columns but when I add a date to the...
I just got a 2 month gig and I need to allow my users to modify and save changes to excel files that generate reports.
I tried opening the file directly as a hyperlink and I could modify the data and a prompt pops up asking me to save.
i want to keep the 'open directly in IE' funtionality but...
some of my files disappear when browsing the network...
It doesn't matter if I map a drive or not.
The files are still on the file server but they disappear intermittently...
I have no idea what is it...
It isn't a connection problem or a virus problem
I have scanned repeatedly for viruses...
I have an access Server AS5300 with a voice card and a quad t1/pri option card.
It came with an invalid IOS image and I'm not sure which feature set I should download from cisco.
Can anyone help??
Akil Mieres
MCSE, MCP, Inet+, A+
We have two remote offices that are to be linked wirelessly.
at one officec we have 4 T1's that carry voice data, which we need to backhaul to the main office.
anyone know how I could achieve this over this wireless link??
at the main office we have an AS5300 enabled for voice data.
the two...
does anyone no anything about mgx 8800 switches
we have to configure an 8800 switch with AUSM, VISM, SRM and PXM cards and I have no clue where to start
can anyone help!!???
I was trying to upgrade windows 2000 pro machine with service pack 3 and in the middle the machine restarted and was caught in a rebooting loop.
I removed the Hard disk to test in another PC and it booted...
I don't know what the problem is...
I replaced the cmos battery, switched ide cables...
I need some info on setting up a call center where folks can come in to make calls state to state using the inter net...
I was thinking of adding some voice trunk card to a windows server and linking to a gatekeeper...
is this feasible???
Hey, I have a flash menu that uses arrays to generate the links
this is the code I used to load the page in the current window
links[0]="wit-abs.htm", target="_self";
but when I click the link it opens another window
how do I fix this???
hey,
i have a catalyst 2948g-l3 48 port switch nd a 3600 router.
my switch runs ios v 12.0
i don't have a firewall but i want to use my switch to separate my internet services (dns, web server , etc) from my lan and email.
I know it should be easy but i'm a t a loss. I was thinking about...
we're a start up wireless ISP and we have a tsunami multi point network connected to a backhaul at our hq with a tsunami 45 wireless bridge.
our backhaul consists of thre win2k servers, cisco 3640 router, cisco as5300 and a layer 3 cisco 2948 catalyst switch.
currently we use emerald 4.5 as...
i accidentally erased my boot flash img from a 2948 catalyst switch.
i'm trying to update it in rommon off a local PC but keep getting an error saying file not valid executable. i'm using hyper terminal as my terminal emulator.
could anyone tell the procedure to do this from rommon???
thanx
i have an exchange 2000 server installed w/ sp3.
everytime I create a new user the mailbox is created but no email address is created. I try to mail enable the user and only move mailbox, delete mailbox are visible.
i can't even see the mail box in systme manager.. i tried searching the forum...
hey guys don't laugh, but i accidentally deleted index.html that raq4 uses for web admin and i never backed it up.
odes anyone know how i can get a copy of this file????
HELP!!
ok i have this html page i want to send as an html email and i don't know how,
first time i'm trying this...
can you guys hellp me? we have a cobalt raq4 web server that's asp enabled, if that'll help.
thanx
Hey guys i need your help!!!!
i'm still much of a newbie (you can tell by the # of threads i have lol)...
we have an AS5300 dial up server and a client of ours wants there employees to dial in theough us and have access to their server. to me it sounds like a VPN situation
I'm thinking to...
I have a 3640 Router and I want to setup a VPN solution for our clients would i still need VPN sofware?
Which can I use? Can i use connection manager for windows or something like that?
Ok i have a cisco 3640 router that is configured to connect to a satellite network through a modem. Everytime the satelllite takes a hit we have to restart the modem to get the circuit back up. Nothing is wrong on the satllite side since every othe customer seems to be running fine. Currently we...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.