User Profile
pillaisg
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Count the instances of occurrence based on criteria.
I have used countif function for identifying the number of occcurance of a value in a specific column. Upon using this function, the value returned is the total number of occurrences whereas what is required is the number of instances in a sequence. For example, Fruit Using Countif Required info. Apple 3 1 Orange 2 1 Banana 4 1 Apple 3 2 Apple 3 3 Banana 4 2 Banana 4 3 Banana 4 4 Orange 2 2 Appreciate a solution for getting the required info.Solved503Views0likes3CommentsDate format in a criteria (need month instead of date)
Trying to get the month instead of the date as the criteria to get the sumifs in cell B4 Refer the attached file.... I have populated a database which shows the date of transaction on column B. (there is a filter given on Row: 9 (Cell : B9) shows month eventhough the date is entered. I wish to do the same in cell: B4 (Instead of dates I want to provide the month) such that it gives the sumifs based on the complete month. Can anyone show the path forward. Thanks in advance...Solved3.7KViews0likes8CommentsReturning value based on certain criteria.
Hi, I am trying to automate as mentioned below the test excel file is attached for further understanding... The rates of the consignment are given in sheet "test". In Sheet " work_sheet" I need to populate the rate/kg (column N) based on the consignor (Column F) and the type of delivery as selection made in (column J). These information shall be looked up from sheet "test". Any help Please.... Eg.. If Column F - A is the consignor and Column - J is "cold chain" then the value shall be 45 or if Column J is " Normal" the value shall be 35... Thanks in advance...Solved1KViews0likes3CommentsData Validation.
Hi, I want to make data validation in Column E for that I have made a dynamic named range. The dynamic named range has been given in data validation pop-up menu Source. As required it is appearing the pull down menu.. but still the cell is allowing to key in information. I wish the user to use the pull-down menu only and should not allow to key in information manually. How can this be done? Can anybody helpme to understand where I had gone wrong. Regards & thanks in advance Sreekanth Pillai604Views0likes1CommentIF -Isblank function to check two cells are blank
Hi I was putting a formula in column P =IF(ISBLANK(M3),K3*N3,M3*N3)+O3 which checks if there is any value is there in column M and takes the rest calculation if M is blank... and if there is no value in M & K it returns 0. If both M and K columns are blank I wish to get the value in P as blank... I don't want 0 to appear Is there any possible way ….. Please guide... Regards & thanks in advance.Solved75KViews0likes8Comments
Groups
Recent Blog Articles
No content to show