Tech Support Guy banner
Cancel

Search Results for ‘counta’

Discussions Showcase Albums Media Media Comments Tags

1-1 of 1 Results

Search Tags

acer amd android asus audio battery bios black screen blue screen blue screen of death bluetooth boot bsod chrome computer connection cpu crash dell desktop display driver drivers email error ethernet excel freeze freezing game games gaming google gpu graphic card graphics card hard drive hardware hdd hdmi help help asap internet internet access internet connection issue keyboard lag lan laptop lenovo linux mac malware memory microphone modem monitor motherboard mouse msi network networking nvidia outlook pc build power power supply printer problem psu ram recovery router screen security server slow software sound ssd storage update upgrade usb video virus vpn wifi win 10 window 10 windows windows 10 windows 10 (x64) windows 7 windows 8 windows 8.1 windows xp windows10 wireless
  1. Business Applications
    Problem: I am using the formula: =INDEX(G3:G12,COUNTA(G3:G12)) to extract the last number in a range of 10 cells G3:G12. Some of the cells are blank. It works until I enter a formula (for example in cell G4: =IF(B4="","",G3) to keep the G3:G15 cells blank if an adjacent cell, say B4, is blank...
    blank cells counta index
1-1 of 1 Results
Top