shows

I am attempting to create a Countifs formula. I am trying to figure out how to count if the cell is not empty. =COUNTIFS(B:B,B2,E:E, E2 is not NULL) The above formula shows (I hope) what I am trying to do. Any help please?

Hi everyone, I hope this is only a setup condition that someone identifies, but the transition from Windows 7 and Excel 2010 to Windows 10 and Excel 2016 has caused a lot of agita. For starters, environ("username") was not recognized (compile error Can't find project or library). Found out...

Hello. I am copying dates to another sheet then after pasting it shows long date but when trying to filter it it still shows long dates. I can't filter it with years..but I cant find it even changing format to dates. Please help.

I have a specialist font for garment care symbols (Medium iron, do no wash, dry clean only, etc) which I need to show in a drop down. The font I have installed shows the actual symbols in the cell but when the drop down is clicked it shows the alphanumeric characters (t, f, x ,!, etc). Is...

It's a pretty simple function - just look down the column range and display the cell that is not blank... =VLOOKUP("?*",A2:A12,1,0) It works when there is text in the cell - but gives an error when the cell shows a number? What is the fix? Thanks for your help!

Hi, I created a pivot table with and dragged a column under the report filter. On the top of the Pivot table, the pivot table normally has a filter above the report filter, in this case it just shows a drop down list, no filter. Can you please tell me what I'm doing wrong? Thanks

I want to double click on a row, application.workbook.worksheet(1).range ("A1"). When I double click on it it shows a pop out a userform Thank you in advance

Hi there Good morning I have a spreadsheet which has a few date columns and I wantto make use that however enter the date that it always shows in the same formatno matter how they type in the date. For example, you type 3rd March 2019 it shows as03/03/2019. Does any body have any ides to...

Hello, I'm hoping someone can help me figure out a formula. I am trying to conditionally format when the value of "1" shows up consecutively twice with one color and conditionally format it if it shows up 3 consecutive times with a different color. Here's my example: C4 = 1 C5 = 1 C6 = 0 C7...

on a daily basis, i run a pivot where the source data (which is on a separate sheet) has the latest date data on the top and then the day before data on the bottom of the same sheet. the date column is put to the "column labels" of the pivot...some days , the latest date in the pivot shows on...

Microsoft Excel 2007 Column P52 contains this formula: =IF(C52>10,IF(E52>15,IF(G52>20,IF(I52>50,IF(K52>100,"Pass","Fail")),"Fail"))) Columns C, E, G, I, K contain marks in numerical. My problem: If I52 is less than 50 result in P52 should show "Fail". Instead it shows "FALSE"...

Please see the imagine. https://imgur.com/a/haW7m1x I have a table of information. you can seen cell C15 shows certification number is 2. What formula should I use in cell C16 so it shows 123, 321, 111. concatenate unique values only, based on criteria without macros? How is it done...

When creating a hyperlinks for other users, upon looking further, hovering over the link it shows the directories, the file path of MY computer. i'e. file///C:\Users\User\Documents\Excel\filename.xlsm. No wonder I can't share it. Thanks, ~Jim

In Sheet1 I have values in A2:A91. In Sheet2 I want to add VBA code which when run shows the value of Sheet1.A2 in Sheet2.B2, but when run a second time it shows the value of Sheet1.A3 in Sheet2.B2, then when run a third time it shows the value of Sheet1.A4 in Sheet2.B2, etc, etc, right up to...

I am doing a sum formula and need some help on rounding. One of my examples: 77.8 (shows as 78) minus 82.5 = -4.7 How do I get it to show a total of 4.5? Because in reality 78 - 82.5 = -4.5 Another one: 109.1 (shows as 109) minus 95.5 = 13.6 but I really need it to say 13.5 Any help...

I have a client who is using Excel Version 16.24 (Office 365 Subscription) on a new MacBook Pro. The workbook has 8 worksheets. Two of them have all the columns to the right of column "H" deleted. When they view either of those two worksheets, it shows the columns A through H, but then to the...

I created these formulas on a separate sheet and I need help with changing it so when the source sheet is filtered it only shows what is filtered and not all the data, any help would be greatly appreciated! =SUMIFS(OT_COMP!I2:I1048576,OT_COMP!B2:B1048576,"OT",OT_COMP!E2:E1048576,"Place Holder")...

Occasionally, I will try to enter a formula to a cell but the cell interprets the typing as text. E.G. I type "= B1 + 2" into A1. Rather than the result of the calculation appearing in the A1 cell, "= B1 + 2" shows in the cell. Why does this happen, please. Thank you.

Hi I understand both of them but I really do not see when I need to use one over the other. Is there any example that shows we can only use one over the other? Thank you so much.

Hello, I'm looking for a formula that goes in each row of column P that finds which number shows up first (between columns M and N) in the unsorted array (A through K). I have pasted the results I'm looking for in column P....For example, in Row 2 the formula should look for whether 54.3% or 0%...