Search results

Hi, Greetings Happy new year 2017, I am trying to create a summary from a table but zeros are making problem for me. Any ideas. I just want to add only products which were sold to any company. Thanks

Hi Guys & Grlz, I was working on this database and got stuck, i hope some one can help? The idea is "A company keeping tracking of renting equipments and customers. The customer can take multiple equipments. Each equipment has a unique ID. (alphanumeric - XXXX#####) depending on the selection...

Hi, Is it possible to make the custom icon set appear beside TEXT cell ? I could not find nice icon any recommendations would be appreciated :)

Hi, I am having little problem here anyone with suggestion ? i want to display in chart data only upto selected month.

Hi, how can i search and move date to other sheet as shown on sheet 2.

Hi, i am adding the previous quantities by using the below formula in excel its working fine but when i put it spreadsheet its not working H1 : is my selection month Row B3:M3 is my date Row B4:M4 is my data which is i am adding using above formula.:awesome: Thanks

i want to calculate the survey result based on my data.

Hi, Did anyone tried to link excel data with visio 2013 to create graphs ? I was trying to link excel data with visio by: (try any data) so if i change value i excel it should also reflects in visio graphs. In Vision 2013, Under Data Menu >Link Data to Shapes >Data Graphics I like...

Hi, I m really tired today, i wanted to make a chart like shown. how can i make . thanks

Helloo, I have a big data and its growing, what i was trying to do was search only between specified dates. But couldn't :(. Sample attached.

Hi everyone, Hope you are doing fine, i have a question using the mid () function is it possible to find (to go at) of a string ? e.g. In a cell i have 1. abc001 [extra space]a quick brown jumps over the lazy dog.[extra spaces here i dont know how many btw i tried trim()] 2. abc002 A...

Hello Friends, Hope you are doin' fine. Almost a year ago thanks to Mr. Debraj who helped me in this below vb code which worked perfect. Sub Copy_Stuff1() Dim cell As Range, rr As Long rr = 2 Application.ScreenUpdating = False Sheets("Sheet1").Range("A2:A3000").ClearContents For Each cell In...

I am trying to search from a table but its giving me a #REF err. =INDEX(F1:O27,MATCH('Original Data'!G2,Data!$F$3:$F$27,0),MATCH('Original Data'!I2,Data!$G$3:$G$27,0),MATCH('Original Data'!J2,Data!$H$1:$O$1,0)) What i have is like this: Table: Sites Types CO1 CO2 CO3...

Why my match is returning #N/A in this formula ? INDEX('Project'!B:B,MATCH(IF(LEN(A5)=1,A5,left(A5)),'Project'!A:A,1))

Hi, I was looking for list of software's used by the Chandoos , i tried to search here in new cool lookin' forum but i wasn't able to find. Btw it was easy to search in previous forum. I know there was a list .. thanks.

I want to change the file name based on my cell A1. eg. Cell A4 ='D:Read Data[13-259.2 Price.xls]WP'!A22 & If cell A1 has any file name then all formula must change to that file name automatically otherwise otherwise remain same. A1=13-260 Price.xls

Hi, when ever i open any excel file there is message "Protected View........Enable Editing" & when i click all my excel sheets and horizontal and vertical scroll bars disappear. Then i have to go to options and select all above options to continue my work. Whats causing this problem ...

Hi,I was trying to make a selection based on multiple criteria but unable find some solution.. I want in H4 ratting based on my criteria on other sheet. http://www.fileconvoy.com/dfl.php?id=g2c33111cc4afabed99930038124aa95e869bc63d7 Thanks

Hi, I searched the net and this forum but found not solution. I want the below code to look in each Jan13, Feb13 & Mar13 and put all data in one column under sheet1 from C17. But this code this only working for the last sheet (i.e Mar13)?? Sub Copy_Sheets() Dim ws As Worksheet...

What i am trying to achieve is create a file and link all files on network drive (as i have to copy manually), File names are always 01 Jan 2013, 01 Feb 2013,01 Mar 2013, ... so on & usually Data is only on Sheet1 Starting from A6 to O100. Problem is sometimes other peoples have opened these...

This formula suppose to return any value from C8:C567 based on matching value A2. 'INDEX(dps!$C$8:$C$567,MATCH(A2,$AHR$8:$BBS$567,0)) but match here return #NA. Why ? btw column C has alphabets, #s & empty cells

How can i add additional condition for not selecting numbers (or only selecting text data) from dps sheet ?

How can i count and sum cells based color in excel without using VB and i m using standard colors no conditional formatting ?

I have a Master_sheet with lot of data column D is DATE ([$-409]d-mmm-yy;@) & column G is (=D-today()). In O1 date ([$-409]d-mmm;@) & R1 date (=DATE(YEAR(O1),MONTH(O1)+3,DAY(O1))-1). I want is when i date any date from O1 (drop down list). Only column A, B, D, E & F data which falls between...