#formulahelp

  1. K

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also ? how its possible on VBA coding ???

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...
    • krunal123
    • Thread
    • #conditional formatting #excel #expert #excel #formula #confused #excel query #formulahelp #pivotable #powepivot #powerquery #vba #vba #excel #vba #excel #if #vba #excel #pleasehelp excel & if tracking system vba & conditions
    • Replies: 0
    • Forum: Excel Questions
  2. K

    *How can I show a icon in Excel when I click on a particular cell, if i will click after open Userform ? Icon Move After cell Selection.

    @how can I show a icon in Excel when I click on a Description column (Range (A15:A30) , if i will click after open Userform ? Icon Move After cell Selection. kindly Need VBA Coding
    • krunal123
    • Thread
    • # new post #excel #excel vba #combobox #excel #formula #confused #excelvba #formulahelp #invoice #powepivot #powerquery #userform #vba #combine #userforms #userforms #excel #newbie #vba #vba #excel #vba help #vbatricks
    • Replies: 0
    • Forum: Excel Questions
  3. Q

    Rename values based on multiple criteria

    In this data set there are 3 separate policies that are either have 6 month or 12 month terms. I want to define each policy as 'NEW' for the first 12 months - i.e. For ID '01' in E2:E4 it is labeled as 'New' only once and I need a formula to turn it into F2:F4. I only need to change New/Renew...
  4. K

    @HOW TO GET AUTO SERIAL NUMBERING with Condition , If Tracking "TO" and set Auto Serial Numbering

    • krunal123
    • Thread
    • #condition formatting #database #pivottable#vba #excel #comparison #excel #pivot #excel query #excel question #excelexport #filter #filterwithmultiplecriteria #formulahelp #if #if #match #index #pivot table#fiilter
    • Replies: 1
    • Forum: Excel Questions
  5. A

    Calculate number of sickness days with rolling shift patterns

    I am looking to find out if there is a way to use excel formula to work out the cumulative number of working days a employee has been absent for when they work shift patterns So if the shift patterns are 4 on 4off, 2 days week one and 5 days week day two and the last shift pattern we have is 2...
    • Aiburto
    • Thread
    • #excel #formulahelp count & count ifs counting worked days if & countif if & network network days networkdays.intl no end date shifts sum work day
    • Replies: 4
    • Forum: Excel Questions
  6. K

    How to Highlight Cell color After another "Invoice No." Value is Bold Text ???

    • krunal123
    • Thread
    • #excel #excel #comparison #excel #discrepancies #excel #error #excel #expert #excel #file error #excel #formula #confused #excel #minimum #index #excel #password #macro #excel #pivot #formula #formulahelp
    • Replies: 1
    • Forum: Excel Questions
  7. K

    How to change month After select Dropdown list ???

    • krunal123
    • Thread
    • #condition formatting #conditional formatting #excel #excel #comparison #excel #error #excel #formula #confused #excel #minimum #index #excel question #excel tutorial #formulahelp #pivot table #pivot table#fiilter #pivot tables #tables #sumif #indirect #index #vba #excel #if formula #explaination
    • Replies: 6
    • Forum: Excel Questions
  8. L

    HELP: TRIMMEAN + AVERAGEIF FUNCTION

    Hey there, Context: I want to remove the top and bottom 3% of outliers from the AVERAGE V7 of a YouTube channel that has "BR" in its name Excel keeps wanting to multiply the trimmean and my averageif function together..... how can I edit it to *NOT* do that?
  9. K

    How to set Custom Formatting via Formula?

    My Formula Problem this above condition , Not show Proper Format We Need this Format Result : EXP/025/21-22 Kindly Correction Below Formula , and Show Perfect Formula in this case =LEFT("EXP",3)&"/"&MID(A2,5,3)&"/21-22" Help me !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    • krunal123
    • Thread
    • #chart #conditional formatting #deskboard #dynamic filter #dynamicranges #easy excel #excel #excel #comparison #excel #error #excel #formula #confused #excel guru #excel logic #excel question #excel tutorial #filter #formulahelp #formulas #pivottable #pivot #powepivot #powerquery excel & formula
    • Replies: 7
    • Forum: Excel Questions
  10. K

    How to Match workbook to other workbook data & Get status

    How to Match workbook to other workbook data & Get status (HOW To MATCH "BOOK2" WITH "BOOK1" , All data Match , to Get Status and Highlight 4 CELL matching How it possible ???
    • krunal123
    • Thread
    • #advance excel #conditional formatting #double match #excel #excel #comparison #excel #formula #confused #excelquestion #formulahelp #pivottable #pivot #query #vba #excel
    • Replies: 1
    • Forum: Excel Questions
  11. K

    HOW TO MATCH DATA ONE WORKBOOK TO OTHER WORKBOOK & MATCHING DATA

    # 1st Condition : MATCH Data 1st "SHEET 1 WITH '"SHEET 2" # 2nd Condition : "SHEET 2" MATCH DATA with other Workbook "SHEET 1" like this BOTH CONDITION MATCH AFTER SHOW ME STATUS " YES / NO " in Worksheet 2 > SHEET 1
    • krunal123
    • Thread
    • # excel #conditional formatting #data mating #double match #excel #formula #confused #excel query #excel question #formulahelp #matching #searching #pivotable #power query #vba excel & lookup & search
    • Replies: 1
    • Forum: Excel Questions
  12. H

    formula question

    Hi all, I need help writing a formula for column 'W'. If Columns U and V contain numbers, I would like column W to display the sum value. If, however, columns U and V contain 'NA', I would like column W to also display 'NA' Please see image below. Any help much appreciated!
  13. Tucker2008

    Find Latest Alpha Character Associated with Variable

    All, Is there a formula in Excel that can search for the Part Number in COL A, find the latest Alpha instance in Column B and Tag in Col C. Result would be below. Part #12345....C is latest Letter in Alphabet, Tag in Col C as such????? Any, all help would be greatly appreciated. A B C...
  14. N

    Complex formula to calculate an end date with rules - Please HELP!!

    Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this. <tbody> Start date (input) Eligible Months (input) Age 50 (Input) Age 55 (input) Rule62 (input) Age 62 (Input) Leave end date 06/1/2019 12.5 7/1/2014 07/1/2019 09/1/2019...
  15. L

    Help....formula

    <tbody> REF NO ADRESS RPT NO TYPE 17-65973 123 MAIN 17-09039 ARR 17-09039 ARR </tbody> Hello, I am having difficulty with a spreadsheet. I have thousands of rows of data, similar to what's above. I want to be able to copy into blank cells if there is data in the row above...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top