Question Cagtegory: Excel: Forumlas
Filter by
Filter by
Questions Per Page:
• ## How to change this formula?

|————— |———————-| |Given Names| First Given Name  | |————— |———————-| |John George  | John              …

Expert Asked on August 6, 2018 in
• 45 views
• ## Adding and Subtracting Time

=IF(AND(ISBLANK(A4),ISBLANK(B4)),””,IF(B4=””,TO-A4+(TO<A4)*24,IF(B4<=”0″,B4-A4+(B4<A4)*24))) A4 = Driver Time In B4 = Manual over ride of a driver’s Time Out’ TO = A set …

Top Contributor Asked on October 31, 2017 in
• 132 views
• ## need correction in formula

Hello P N Rao sir, i have below formula which will calculate last quarter calls count , but late i …

Top Contributor Asked on May 12, 2017 in
• 169 views
• ## Hiding formula in excel using VBA

Hi , i have sheet with multiple complex formula in cell, after creating the report they are visible to all …

Top Contributor Asked on April 19, 2017 in
• 218 views
• ## Formula to count number occurrences of value when it has 2 report in same sheet

Hi I am looking for a formula which will count number of calls in  H column with  different severity In …

Top Contributor Asked on April 17, 2017 in
• 217 views
• ## How to make formula in cell constant

Hi i have work book with 8 sheets with summary sheet , in summary sheet all the formulas are copied …

Top Contributor Asked on April 15, 2017 in
• 232 views
• ## Convert Countif more dynamic

I have below CountIf formula where I have to enter the date manually, I am looking for more dynamic formula …

Top Contributor Asked on April 13, 2017 in
• 235 views
• ## Select Score based on Answer Selected

Can anyone provide me with a formula or script that will return the point value based on which answer is …

Participant Asked on April 13, 2017 in
• 186 views
• ## Hi experts, Can someone help me create a connected VBA data validation to provide a list of responses as below.

Job Family: Select from 5 (HR/Operations/Finance/Sales/Consulting) Job Level: GM/Senior Manager/Senior GM/IC Position title: List of positions I need the VBA …

Participant Asked on April 3, 2017 in
• 199 views
• ## Excel Show current month information only

Hi All, I have the table below, however I want the following rule to be applicable to my table, could …

Top Contributor Asked on January 27, 2017 in
• 336 views
• ## Add up values a column if another cell equals a certian value from a picklist

Any one know how to count values in one column range if on the same row within another cell contains …

Top Contributor Asked on November 10, 2016 in
• 295 views