Search results

Thanks. Working fine

One more query please I have a figure in Cell A which I keep changing in Cell B I want the output to be 1% of Cell A or Rs 50, whichever is lower What should be the command I have to give in Cell B ? Thanks for advising

It is working for 115 rows brilliantly. How do I extend the range to 500 rows ? Thanks for advising Working flawlessly. Problem solved Thanks everyone for all your efforts. Really appreciate it.

Its not a sensitive data file Its for statistical purposes I have zipped and attached the file so that you can download it I shall be grateful if you can correct the formula and repost it Thanks for advising

Did as advised I am getting the correct answer for only 3 values 0.25, 0.50 & o.75.. all other are values are o although they also occur in similar numbers

Absolutely correct As soon as I substituted my data, all became 0 You have hidden column F Do I have to do some more cut paste of the formulas ? Thanks for advising

Hi You are getting me wrong. I want to know how many numbers in the entire database end with .05, how many with .010 and so on to see which number occurs maximum times Thanks for advising

Excel sheet sent on the email id If you can find the solution, I shall be grateful if you send the correct formula in the sheet with all the data as it is in return mail Thanks for advising

Nope Extracted the digits as advised Answer still 0 If you can PM me your email id, I can email you the excel sheet. The system is not allowing me to upload the .xls sheet on the site Please advise alternative solution

=COUNTIF(B1:B251,"*05") Gave the following command, but the answer was 0 (The entire data is in B Column) Can you please give me the correct formula Thanks for advising

Hi I want to find out how many times a number ends in .05, .10 , .15 etc. in the excel sheet As the data runs in thousands it is not possible to do it manually The excel sheet has number like 10.05, 65.35, 75.80 etc. (all multiples of 5 paisa) I shall be grateful if the members can give me...

As the Project was delayed, We did not purchase the computer Anyways, today I went to S.P. Road and got the following quotes I5 3570 12,100 I7 3770 17200 Motherboard Asus P8H77 7150 Gigabyte MD3H 5550 2X4GB Corsair Vengeance 1600 Mhz 4500 Cooler Master 311 2100 Seasonic 520W 3950 All...

Brand new processor available with free shipping from Flipkart for Rs 11,400/- http://www.flipkart.com/amd-fx-8350/p/itmdfv4fffknf29s?pid=PSRDFV4DFPRBTSWY&ref=21d23182-d06c-4cee-a544-a144b013bc6f&srno=t_1&otracker=from-search&query=fx 8350 Revise your Processor price for a sale

The Cable TV owner was out Has responded yesterday It is possible to put the thumbnails on the Feed for 4 channels for the owners to see even through STB We have to isolate 4 channels from the PC and give the feed into the Modulator that he has installed which we want to broadcast. Is it...

Owner of the Cable agency not responding. Busy in transition of customers from Analog to STB, i think Hoping to hear from him over the weekend Will post the discussions

I could not understand your question. Previously when we did not have the stb system, we had 2 CCTV camera feeds which were streamed into the existing cable tv network using a modulator device There were 2 dedicated channels for the same, and the residents could see the feeds when they wanted by...

As I have mentioned earlier, the internet connections have pathetic upload speed and also have a recurring cost. So If the cable TV works out, there is nothing like it Our order of preference would be 1. Existing Cable TV network 2. Limited area Wireless network 3. Internet based system...

DVRs are chain connected DVR2 to DVR1 to PC So the cable coming from DVR1 is to be connected to to the modulator or the output that I am getting from my PC to be displayed on the TV has to be connected to the Modulator ? Thanks for advising

We already have the old equipment to send the CCTV images on the cable network, which is owned by us. Even if the Cable is owned by the Building, the Cable TV data is also running on the same cable ? So if an owner who has subscribed to Tata Sky, connects his TV to the Cable to see only the...

Most Welcome I am in Jayanagar, Bangalore I will PM you my mobile number You can contact me if necessary Thanks For advising