shows

Hello! I almost managed to make a formula I needed, but it shows values from current sheet instead of sheet I'm interested in. =INDIRECT(ADDRESS(MATCH("Summary";Values!$A:$A;0);MATCH("2018-12-02";Values!4:4;0))) It successfully finds row number, which has "Summary" as header and column with...

Hi I am using below formula in a cell, F4 =(IF(AND(B4="MONEY TRANSFER",E4="1"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4),IF(AND(B4="MONEY TRANSFER",E4="11"),SUMIFS($R$4:$R$8,$P$4:$P$8,"<="&D4,$Q$4:$Q$8,">="&D4)+3.5,IF(AND(B4="MONEY...

<tbody> product code Jan price Feb price MAR PRICE % / Different 132 10 10 11 ?? 399 12 12 12 398 9 8 15 </tbody> Hi All I have some sales data.As the table above. I would like to see if price same for 3 month it shows "nothing" in the last column. if price are...

Hi there, I have been trying to find a solution everywhere, but have had no luck thus far, so hoping someone here can help me out! I have two tables that sit alongside one another. One table contains the data with a date where an event occurred. This data is 5000 rows worth. The second table...

Type: dd/mm/yy "("ddd")";@ Shows: 01/04/18 (Sun) However, I want "Sun" to only show "Su". The following idea doesn't work: Type: dd/mm/yy "("dd")";@ Shows: 01/04/18 (01) Any ideas?

Hi All, New to the Forum so Hello to everyone. I am looking for a formula or formatting condition that will add 0.2 to a cell that ends in .80 to .99 but will not change if its below .80. For example if a cell contains 26.89 I want it to show 27.09 and if it shows 17.69 I want it to remain the...

Hi, I want to create a waterfall chart that shows the accumulative value of rainfall for each year. So basically the line can only go up. The X-axis shows the days from 0 to 366 The Y-axis shows the rainfall value in mm (0 to 1500) I am able to do that for one year but if I want to add a second...

Hi I can not find any benefit of this option (find the last cell)? Any example please that shows I really need to use that option? Thank you.

Hi I am currently using the following formula to successfully flag up when a person is either due to pay or if they haven't paid by the end of the month when payment was due. When less than 30days the cell shows "due x number of days ago". When over 30 days it shows 'Overdue and the number of...

Hi I am trying to ensure that a range of excel cells shows exactly 8 digits. This part is appears to be easy by using Data Validation to set Text lenght to equal to 8. However as some of the numbers include one or two leading zeros which I need to show this data validation shows it as an error...

Hi All, l'm wondering how can l setup the formula for the situation below: If column A appears more than one times, it will count from A to ZZ. If just only appears one time, then just shows ZZ. A B ---------- 1 A 1 B 1 C 2 ZZ 3 ZZ 6 ZZ 1 D Any ideas of how to...

I run a macro to screen scrape data from our companies database (IBM-PComm) Some of the data contains numbers and a letter, for example 30E82. This number though is copied into my spreadsheet as scientific format and shows like this 3.00E+92. When I try to re-format it to a number it then...

hi, i have attached a link to a source file that shows an example of what I'm aiming to do. Basically a 4 box grid exists. If a person in the list below is given a number between 1 and 4 a 'dot' shows up on the grid? thank...

I'm attempting to enter data by hand into a worksheet. I have selected cells and formatted it to text only. When entering -7.82 dB it adds = and some other nonsense ahead of what I have typed. And I can't remove it. Attempting to has highlighted a Cell blue and Hung me on something as R-click...

H I thank you for helping me with this. the situation is on the 1st sheet contains several numbers lined up in column A, this number represents the row number on sheet 2 ( sheet 2 contains the data) I there a way in macro or ay means that I can filter sheet 2 that only shows whats is being...

Hi, I installed a file which was DoneEx It was to allow me to insert a bar code ex. Basically it wasnt what i was looking for so i uninstalled it of which was Monday. Today when i open an excel file i see a message p[op up to say DoneEx could not be found and it shows me the path of where it...

Hi Guys, Can anyone help with the formula I would need to use to have cell C1 show the words "Level 5" in the attached example? Column B shows a number of 'points' and Cell B1 is a changing value, if B1 was showing a figure above 10,000 but below 25,000 then cell C1 should show 'Level 2'...

Hello First post I know how to calculate the overall daily interest rate on a loan but what i would like to do if possible is to split this out into financial years So for example if a loan was taken out on 1 November 2018 and matured on 31 October 2021 (three years) I can calculate the...

I hope my title makes sence. When I copy the Vlookup formula down the column waiting for the lookup field to be entered it shows the "#N/A". How do I make that field blank or hide the "#N/A" until the lookup field is populated? Thanks!!!

Hi I entered time like this 1:30:44 am but excel only shows 1:30 am. Why is that and how can I fix that? thank you so much.